OpenEuphoria

Re: Reading comma delimited .csv data files

• Posted by Kat <kat12 at co?sahs.n?t> Jan 21, 2008
• 769 views

JAYBEEDEE wrote:
> 
> 
> 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?

Strtok was made for this task. It can retrieve, insert, find, match, and sort 
such records.

Kat