Re: CSV files

[Eric Dimick Eastman <erice@ONTKO.COM>]

Maria,

Ray Ontko wrote a library that I use for reading/writing CSV files.
 This handles all the intricacies of commas or quotes appearing in your
data.

http://www.ontko.com/sqr/csv.html

In answer to your other question:  SQR can read any file format.  The
question is:  How much work are you willing ot do in order to read that
kind of file?  For example, we are currently kicking around an XML
parser library that would take significant work to implement.  The two
easiest file formats are CSV (or other delimited files) and fixed length
text files.

Hope this Helps,
Eric


Brickl, Maria wrote:

>I have this program where it looks at this CSV file and inserts data into a
>table if there is new data. I got this error saying that the value was too
>large for the column. After looking at the data it was having problems with
>I realized that there are commas in the value and I'm wondering if that may
>be the cause of the problem. Does anyone know a work around for commas in
>values of a CSV file?
>
>*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>Maria K Brickl
>Information Systems Programmer/Analyst
>University of Wisconsin Colleges
>780 Regent St, PO Box 8680, Madison, WI  53708-8680
>Phone: 608.265.2677 / Fax: 608.265.5770
>*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
>
>
>
>