c Read from csv file

Question

I have this code which is supposed to cout in console the information from the  csv file   while file good           getline file  ID            cout  lt  lt   ID     lt  lt  ID  lt  lt              getline file  nome             cout  lt  lt   User     lt  lt  nome  lt  lt             getline file  idade             cout  lt  lt   Idade     lt  lt  idade  lt  lt               getline file  genero              cout  lt  lt   Sexo     lt  lt   genero lt  lt              And a csv file that has this  when I open with notepad    0 Filipe 19 M  1 Maria 20 F  2 Walter 60 M   Whenever I run the program the console will display this     My question is why isn t the program repeating those cout messages in every line instead of only in the first one   Btw   nome is name  idade is age  and genero sexo is gender  forgot to translate before creating this post

User · Answer

a csv-file is just like any other file a stream of characters. the getline reads from the file up to a delimiter however in your case the delimiter for the last item is not ' ' as you assume

getline(file, genero, ' ') ;

it is newline \n

so change that line to

getline(file, genero); // \n is default delimiter

User · Answer

Your csv is malformed  The output is not three loopings but just one output   To ensure that this is a single loop  add a counter and increment it with every loop  It should only count to one   This is what your code sees  0 Filipe 19 M n1 Maria 20 F n2 Walter 60 M   Try this  0 Filipe 19 M 1 Maria 20 F 2 Walter 60 M   while file good           getline file  ID            cout  lt  lt   ID     lt  lt  ID  lt  lt              getline file  nome             cout  lt  lt   User     lt  lt  nome  lt  lt             getline file  idade             cout  lt  lt   Idade     lt  lt  idade  lt  lt               getline file  genero       diff     cout  lt  lt   Sexo     lt  lt   genero   diff

User · Answer

You can follow this answer to see many different ways to process CSV in C     In your case  the last call to getline is actually putting the last field of the first line and then all of the remaining lines into the variable genero  This is because there is no space delimiter found up until the end of file  Try changing the space character into a newline instead         getline file  genero  file widen   n       or more succinctly       getline file  genero     In addition  your check for file good   is premature  The last newline in the file is still in the input stream until it gets discarded by the next getline   call for ID  It is at this point that the end of file is detected  so the check should be based on that  You can fix this by changing your while test to be based on the getline   call for ID itself  assuming each line is well formed    while  getline file  ID              cout  lt  lt   ID     lt  lt  ID  lt  lt              getline file  nome             cout  lt  lt   User     lt  lt  nome  lt  lt             getline file  idade             cout  lt  lt   Idade     lt  lt  idade  lt  lt               getline file  genero       cout  lt  lt   Sexo     lt  lt   genero lt  lt             For better error checking  you should check the result of each call to getline

User · Answer

That because your csv file is in invalid format   maybe the line break in your text file is not the  n or  r  and  using c c   to parse text is not a good idea  try awk     awk -F      print  ID   1  tName   2  tAge   3  tGender   4   1 csv  ID 0   Name Filipe Age 19  Gender M  ID 1   Name Maria  Age 20  Gender F  ID 2   Name Walter Age 60  Gender M

[c++] c++ Read from .csv file

Examples related to c++

Examples related to file

Examples related to csv

Examples related to getline