I’m referring to this part of the GAMS wiki: http://interfaces.gams-software.com/doku.php?id=excel:excel#importing_csv_files
I can call a csv file but it returns the following error: ‘Bad or missing delimiter while reading delimited data records.’ Any guidance as to why I’m receiving this error would be appreciated.
My code is below and the csv file is attached.
set
i /R1R29/
j /1530/
k /1*8/;
table ISC(i,j,k)
$ondelim
$include 567allconfigs.csv
$offdelim
–
567allconfigs.csv (22.5 KB)
As far as I can tell the error is due to the third element of the table. The first section of code will solve (using attached CSV file) but the 2nd set of code (using second attachment CSV) will not. Does anyone know how to load a 3 dimensional table from a CSV? I’ve successfully loaded a 3 dimensional table from excel in the past using the same format.
1st set of code - working
set
i relay number /R1R2/
j fault location/12/
table ISC(i,j)
$ondelim
$include test0.csv
$offdelim
2nd set of code - not working
set
i relay number /R1R2/
j fault location/12/
k third dimension /1*2/
table ISC(i,j,k)
$ondelim
$include test1.csv
$offdelim
On Wednesday, 6 June 2012 12:22:31 UTC+4, KJ wrote:
I’m referring to this part of the GAMS wiki: http://interfaces.gams-software.com/doku.php?id=excel:excel#importing_csv_files
I can call a csv file but it returns the following error: ‘Bad or missing delimiter while reading delimited data records.’ Any guidance as to why I’m receiving this error would be appreciated.
My code is below and the csv file is attached.
set
i /R1R29/
j /1530/
k /1*8/;
table ISC(i,j,k)
$ondelim
$include 567allconfigs.csv
$offdelim