DSXchange

Hi,

I am trying to load a csv file. For some reason I am not capturing double quotes.

For example I have a field value like I DON'T "KNOW",ENGLISH

In the above example I need to capture all the charcters like " ' and , to a csv. I tried using Dquote but not working. Can you please help.

Thanks

Where is your input? from sequential file? what is the delimiter? did you try view data when you read your input?

The parallel Sequential File stage is notoriously bad at handling quotes.

Consider using a server Sequential File stage, either in a server job or in a server Shared Container in your parallel job.