DSXchange

Hi,

I have double quotes in data and ds is not recognizing the field

Data looks like this

xxx,yyy,"last,first", "yyyy""",jjj

This is a .csv file and I have given the quote character as double quote.

This record is not being read in sequential file at all, so If I could read this I can strip the extra double quotes inside datastage.

Thanks!!

You do not have double qoute in all fields.
Have the quote character as None and import the data.

But, when I have comma in a field, then I get them in quoted fields

xxx,yyy,"last,first", "yyyy""",jjj

Here the 3rd field is "last,first". If I have the quote as none, then it is considering the third field as last and not reading properly..

You might want to consider using a Server job for this, they are typically much more forgiving when it comes to reading files of this nature. That or leverage the Server Sequential File stage in a Server Shared Container in your PX job.