Convert string to int after reading data from CSV file

Question

I'm trying to read data from a csv file into a vector of structs each containing various values from a football game (offensive team, quarter, down, yards to go, play desc, etc). I'm trying to use stringstream to convert strings to ints but i'm returning junk data.

Data d;  //structs
vector<Data> TeamData;  //vector of structs
string s;
istringstream iss( s );

ifstream myfile;
myfile.open("CSV file here");  //open CSV file


while (  !myfile.eof()  )
{
getline (myfile, d.gameid, ',');  //read to comma, store in d.gameid

getline (myfile, s, ',');  //read to comma
iss >> d.qtr;             //use stringstream to store into d.qtr

repeat for remaining values . . .

The cvs file looks similar to this if you're wondering:

20070906_NO@IND,1,47,25,IND,NO,1,10,31,(2:25) J.Addai up the middle to NO 27 for 4 yards (S.Fujita).,0,0,2007
20070906_NO@IND,1,46,42,IND,NO,2,6,27,(1:42) P.Manning pass deep left to M.Harrison for 27 yards TOUCHDOWN.,0,0,2007

My program returns data like this when i try to output everything of relevance:

Game ID: 20070906_NO@IND
Offensive team: IND
Quarter: 7077994
Down: 4696320
To go: 4670480
Play: (2:25) J.Addai up the middle to NO 27 for 4 yards (S.Fujita).

Game ID: 20070906_NO@IND
Offensive team: IND
Quarter: 7077994
Down: 4696320
To go: 4670480
Play: (1:42) P.Manning pass deep left to M.Harrison for 27 yards TOUCHDOWN.

Community · Accepted Answer · 2017-05-23 12:02:56Z

2

I think you should look at my answer for 'reading floats' Instead of parsing on whitespace parse on commas.

Using ifsstream to read floats

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jul 27, 2015 at 15:09

DannyK

1,51217 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonathan Potter · Accepted Answer · 2013-09-11 02:55:02Z

0

istringstream copies the string you pass it in the constructor, so changes you make to the string following that won't have any effect on the stream. You should construct a new stream, or call the istringstream:str() method to supply a new string, every time the string changes.

getline (myfile, s, ',');  //read to comma
iss.str(s);                // supply new string to stream
iss >> d.qtr;              //use stringstream to store into d.qtr

answered Sep 11, 2013 at 2:55

Jonathan Potter

37.5k4 gold badges73 silver badges86 bronze badges

Collectives™ on Stack Overflow

Convert string to int after reading data from CSV file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related