Help writing to a file

[kpsita]

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

[kandyshandy]

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

[ray.wurlod]

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.