牽著老婆滿街逛

嚴以律己,寬以待人. 三思而后行.
GMail/GTalk: yanglinbo#google.com;
MSN/Email: tx7do#yahoo.com.cn;
QQ: 3 0 3 3 9 6 9 2 0 .

兩個 CSV 解析類

其一：

/* Excerpted from 'The Practice of Programming' */

/* by Brian W. Kernighan and Rob Pike */

#include <iostream>

#include <algorithm>

#include <string>

#include <vector>

using namespace std;

class Csv

{ // read and parse comma-separated values

// sample input: "LU",86.25,"11/4/1998","2:19PM",+4.0625

public:

Csv(istream& fin = cin, string sep = ",") :

fin(fin), fieldsep(sep) {}

int getline(string&);

string getfield(int n);

int getnfield() const { return nfield; }

private:

istream& fin; // input file pointer

string line; // input line

vector<string> field; // field strings

int nfield; // number of fields

string fieldsep; // separator characters

int split();

int endofline(char);

int advplain(const string& line, string& fld, int);

int advquoted(const string& line, string& fld, int);

};

// endofline: check for and consume \r, \n, \r\n, or EOF

int Csv::endofline(char c)

{

int eol;

eol = (c=='\r' || c=='\n');

if (c == '\r')

{

fin.get(c);

if (!fin.eof() && c != '\n')

fin.putback(c); // read too far

}

return eol;

}

// getline: get one line, grow as needed

int Csv::getline(string& str)

{

char c;

for (line = ""; fin.get(c) && !endofline(c); )

line += c;

split();

str = line;

return !fin.eof();

}

// split: split line into fields

int Csv::split()

{

string fld;

int i, j;

nfield = 0;

if (line.length() == 0)

return 0;

i = 0;

do {

if (i < line.length() && line[i] == '"')

j = advquoted(line, fld, ++i); // skip quote

else

j = advplain(line, fld, i);

if (nfield >= field.size())

field.push_back(fld);

else

field[nfield] = fld;

nfield++;

i = j + 1;

} while (j < line.length());

return nfield;

}

// advquoted: quoted field; return index of next separator

int Csv::advquoted(const string& s, string& fld, int i)

{

int j;

fld = "";

for (j = i; j < s.length(); j++)

{

if (s[j] == '"' && s[++j] != '"')

{

int k = s.find_first_of(fieldsep, j);

if (k > s.length()) // no separator found

k = s.length();

for (k -= j; k-- > 0; )

fld += s[j++];

break;

}

fld += s[j];

}

return j;

}

// advplain: unquoted field; return index of next separator

int Csv::advplain(const string& s, string& fld, int i)

{

int j;

j = s.find_first_of(fieldsep, i); // look for separator

if (j > s.length()) // none found

j = s.length();

fld = string(s, i, j-i);

return j;

}

// getfield: return n-th field

string Csv::getfield(int n)

{

if (n < 0 || n >= nfield)

return "";

else

return field[n];

}

// Csvtest main: test Csv class

int main(void)

{

string line;

Csv csv;

while (csv.getline(line) != 0)

{

cout << "line = `" << line <<"'\n";

for (int i = 0; i < csv.getnfield(); i++)

cout << "field[" << i << "] = `"

<< csv.getfield(i) << "'\n";

}

return 0;

}

其二：
來源于：http://www.mayukhbose.com/freebies/c-code.php
頭文件：

#ifndef __CSVPARSE_H_2001_06_07__

#define __CSVPARSE_H_2001_06_07__

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are

met:

* Redistributions of source code must retain the above copyright notice,

this list of conditions and the following disclaimer.

* Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

* Neither the name of Mayukh Bose nor the names of other

contributors may be used to endorse or promote products derived from

this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS

"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT

LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR

A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT

OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,

SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT

LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,

DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY

THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT

(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE

OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

#include <string>

using namespace std;

class CSVParser {

private:

string m_sData;

string::size_type m_nPos;

void SkipSpaces(void);

public:

CSVParser();

const CSVParser & operator << (const string &sIn);

const CSVParser & operator << (const char *sIn);

CSVParser & operator >> (int &nOut);

CSVParser & operator >> (double &nOut);

CSVParser & operator >> (string &sOut);

};

#endif

cpp