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
Help writing to a file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Consider using a server Sequential File stage, either in a server job or in a server Shared Container in your parallel job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.