csv file issue

ArndW · Post by **ArndW** » Fri May 05, 2006 11:43 am

Sudheer,

could you explain the problem a bit more. You said you have a comma delimiter and that is working. What is the format of the rows that are different? Do the rows have the value "..." for just one column?

shepli · Post by **shepli** » Fri May 05, 2006 12:12 pm

One possibility is that you have incomplete rows (rows with delimiters less than expected. If this is the case, when you try to view data on the csv file, you'll get an error message. The problem can be solved by setting (double click on the sequential file / outputs / format) the Missing Column Action as "Pad with empty string".

sudheer05 · Post by **sudheer05** » Tue May 09, 2006 5:06 pm

Thanks for the reply,
I am getting some junk data in a csv file.
I am cleaning the file in unix and then calling it in datastage.

thanks,
Sudheer

rasi · Post by **rasi** » Tue May 09, 2006 6:21 pm

Sudheer

What you can do is read your csv file record as one single string and then inside your transformer check the total commas you expect for good records. Have two links as ouput. One being the good ones which you wanted to use and the other for the rejected records.