Could some1 tell me how to scan a csv file and assigined variable to each of the interger scanned in a csv file
an example of the csv file:
0001,40,,10
how do i scan the csv file and assign 0001 to variable student id, the 40 to variable module 01,the 1 without input entered to module02 and 10 to module03
It depends. For example, if you know the maximum number of characters in a line, then you can use fgets to read line by line, then say, strtok to parse each line. Of course, things would get more difficult if you have to consider say, optionally quoted strings and commas embedded within strings, but if such is not required, then the approach I described could work.
Look up a C++ Reference and learn How To Ask Questions The Smart WayOriginally Posted by Bjarne Stroustrup (2000-10-14)
"...a computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are,in short, a perfect match.." Bill Bryson
but how do i assign a variable with strtok to the part with no input since strtok ignores it
Last edited by vabo; 12-26-2013 at 09:44 AM.
If you find that to be a problem, then use some alternative method of tokenisation, e.g., loop with strchr.
Look up a C++ Reference and learn How To Ask Questions The Smart Way
A simple way to do it would be:
In pseudo code:
If you are the one creating the data, I'd put a 0 into any empty field. It looks too much like data was somehow skipped, if a field is simply empty.Code:for(each field in the row) { while(the next char is not a comma) { put the char into the current field if(the last char was a comma && the current char is a comma) { the field is empty, so assign a 0 or '\0' char to that field. } } }
