Re: Reading comma delimited .csv data files
- Posted by Kat <kat12 at co?sahs.n?t> Jan 21, 2008
- 591 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