Re: CSV files

[Prasanna Menta <pmenta@UMUC.EDU>]

One way is to use the unstring function to unstring the data and then
read the flat file before you insert, an another approach is to make a
show statement of the length of the variable and if there are spaces
trim them before inserting.
First open the file
Next unstring the file using unstring command
Read and insert
Good Luck
Prasanna

"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
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*