Conversion on a field

bobthebuilder · Post by **bobthebuilder** » Wed Mar 22, 2006 9:43 am

All,

I have the following job

DB2 Stage ------> Transformer -----> Sequential File

The sequential file is comma delimited. However I have a field which is of type longVarChar and had commas inside the data. I had been getting the "too many columns in a row error" which I could fix by specifying the quote character as "

The sequential file has to be now subjected to cleansing wherein I will have to set the quote character to 000 and the previous error will spring back. Could anyone help me out with this?

-- Bob

ArndW · Post by **ArndW** » Wed Mar 22, 2006 9:49 am

Is the sequential file comma delimited and do the strings have a valid quote character? If yes, then DS can read it correctly. You will have to specify in the column definition of the source file "column contains delimiters".

Good File format: 1,2,"Hello, Goodbye",4,5
Unusable File format: 1,2,Hello, Goodbye,4,5