Ad:

C++ Discussion Thread
Marked Solved
Views: 11206

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Jul 21st, 2009

Re: Parsing a CSV file separated by semicolons.

Sorry to respond to this late... but I wanted to post info also...

The getline() function has the obnoxious habit of returning a not good() stream for final blank fields...

For a single blank line at the end of input, that's fine... (there's no record) but for blank fields it makes a difference. You can get past the problem by checking the stream state before getting a line.

For simple CSV files (meaning you cannot use the ';' character [or whatever character you've chosen] in the field value) this is a working example:

C++ Syntax (Toggle Plain Text)
#include <deque>
#include <iostream>
#include <sstream>
#include <string>
 
typedef std::deque <std::string> record_t;
typedef std::deque <record_t>    table_t;
 
std::istream& operator >> ( std::istream& ins, table_t& table )
  {
  std::string s;
  table.clear();
 
  while (std::getline( ins, s ))
    {
    std::istringstream ss( s );
    record_t           record;
    std::string        field;
    bool               final = true;
 
    while (std::getline( ss, field, ';' ))
      {
      record.push_back( field );
      final = ss.eof();
      }
    if (!final)
      record.push_back( std::string() );
 
    table.push_back( record );
    }
 
  return ins;
  }
#include <deque>
#include <iostream>
#include <sstream>
#include <string>

typedef std::deque <std::string> record_t;
typedef std::deque <record_t>    table_t;

std::istream& operator >> ( std::istream& ins, table_t& table )
  {
  std::string s;
  table.clear();

  while (std::getline( ins, s ))
    {
    std::istringstream ss( s );
    record_t           record;
    std::string        field;
    bool               final = true;

    while (std::getline( ss, field, ';' ))
      {
      record.push_back( field );
      final = ss.eof();
      }
    if (!final)
      record.push_back( std::string() );

    table.push_back( record );
    }

  return ins;
  }

This will allow you to read all seven fields in a record like:

C++ Syntax (Toggle Plain Text)

one; two;three;four;;six;

Hope this helps.

Duoas

Featured Poster

Reputation Points: 1140

Solved Threads: 229

Postaholic

Offline

2,039 posts
since Oct 2007

Permalink

Jul 23rd, 2009

Re: Parsing a CSV file separated by semicolons.

Click to Expand / Collapse Quote originally posted by Ancient Dragon ...

The only problem with your program is that you need to set local for the stringstream object.
C++ Syntax (Toggle Plain Text)
    while (getline(infile, line))
	{
        stringstream strstr(line);
        string word = "";
	    strstr.imbue(locale("german_germany.1252"));
        while (getline(strstr,word, ';')) 
            all_words.push_back(word);
    }
while (getline(infile, line)) { stringstream strstr(line); string word = ""; strstr.imbue(locale("german_germany.1252")); while (getline(strstr,word, ';')) all_words.push_back(word); }
Attached is the output file I got.

Hi Ancient Dragon. I see that this makes sense, but the commas in the numbers are not being replaced with decimals. I think the reason for this is that things are still in strings and I need to convert them to integer and float values.

For instances when I do all_words[0] + all_words[2] (all_words[0]=2 and all_words[2]=31), I get 231.

How do I convert each indviudal value of my file so that I can specify it either as int, float, or string?

Yaserk88

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Sep 2008

Permalink

Jul 23rd, 2009

Re: Parsing a CSV file separated by semicolons.

I will actually mark this thread as solved and post it as a different problem, because it may be useful for other people. Thanks for the help everyone!

Yaserk88

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Sep 2008

Permalink

Jul 23rd, 2009

Re: Parsing a CSV file separated by semicolons.

Click to Expand / Collapse Quote originally posted by Yaserk88 ...

How do I convert each indviudal value of my file so that I can specify it either as int, float, or string?

Simple substitution -- call find() to locate the comma and replace it with a period.

Ancient Dragon

Sponsor

Team Colleague

Featured Poster

Reputation Points: 5608

Solved Threads: 2282

Retired and Enjoying Life

Offline

21,950 posts
since Aug 2005

Previous
1
Page 2

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C++ Forum Timeline: Inheritance question

Next Thread in C++ Forum Timeline: How to disable a button without using MFC

DaniWeb Message

Cancel Changes

User Name
Password