DSXchange

Hi
I am using a server job. I need to read a file that is comma seperated, but the data in one of the field contains comma. The data is not quoted. datastage interprets this comma as a delimiter and is not readin the data properly. How to overcome this?

Get "them" to supply you with a valid CSV file would be favourite. Commas within data require that character strings be quoted.

Otherwise you're going to have to specify something else as field delimiter - something not in the data at all - and effect your own parsing in a Transformer stage.