reading into an array.

[georges the man]

hey guys,
i am trying to read a csv file into an 3d array.

the file format is the following:
ABC,"12 aug 2006",323.343,5454,4545.4545.4545...
..
...
...
...

for 762 rows and 7 columns.

how can i read this file into a 3D array, one for the column one for the rows and one for the length of the stream..

thanks guys.

[risby]

hey guys,
i am trying to read a csv file into an 3d array.

the file format is the following:
ABC,"12 aug 2006",323.343,5454,4545.4545.4545...
..
...
...
...

for 762 rows and 7 columns.

how can i read this file into a 3D array, one for the column one for the rows and one for the length of the stream..

thanks guys.

You might get a better response if you gave some feedback to the previous attempts to help you, e.g. regarding separating fields in a csv file using fgets() and strtok()

http://www.thescripts.com/forum/post2098535-4.html

The code I posted here can be easily adapted by invoking strcpy() and possibly malloc() instead of simply fprintf() with each field read in. You'll also have to maintain column and row counters to index into your array.

[gasfusion]

you can use getline, but it's only useful if you have a fixed amount of elements on each line of the text file.

    while (!ifile.eof()) {
        getline(ifile,first,',');
        stdArray[j] = first;
        getline(ifile,second,',');
        stdArray[j] = second;
        getline(ifile,third,' ' );
        stdArray[j] = third;
        getline(ifile,last);
        stdArray[j] = last;
}
 

Make sure the file is open of course before you run the loop. The getline will read everything up to your delimiter, in this case it's "," and store it in your array. you can simply change it to a 3d array. Also, when using getline() to get the last element on the row of your cvs file, make sure you don't specify the delimiter, because it'll start reading the next line if you do.
Everything would have been much easier if you had space between elements. You could have used >> operator to read the file because it automatically scans for spaces.