OpenEuphoria

Reading comma delimited .csv data files

• Posted by JAYBEEDEE <daviesjb at liv?ac.u?> Jan 18, 2008
• 613 views

I'm having difficulty in getting Eu to read multiple column data tables created
via Excel
and saved as comma delimited text files.

I'm confused by the get(), gets(), getc() and value() commands.

Using gets() I have no problem in reading data in a single column, but if there
are
more than one, then gets() reads each row (line) as a single element.

For example, the csv file might be of the form:

Month,,
6,,
8,,
1988,,


2,6,8
5,12,25.7
. 
etc

Note 2 blank lines after 1988,, and blank cells in the grid as ,,

I would like to write the data into a sequence emulating 3 horizontal elements
and n rows like

data{{}{}{}}  so that I can extract values using a statement like
cell_value=data[row][col]

So far I'm defeated!  Any suggestions?