Hi,
I am trying to read a csv file which has data like..
abc,bcd,hh"k"lmn
How can i remove the double quotes around "k" and read the file?
any input would be hoghly appreciated.
my current settings are
seqfile stage with comma delim and quote=double.
Thanks,
CSV file with column value with double quote
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You've been here long enough to know about Search function.
Why did you specify Quote=double when clearly this is not true? Why not specify Quote=none (000)?
Why did you specify Quote=double when clearly this is not true? Why not specify Quote=none (000)?
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.
Hi,
Using Convert Function in the transformer double quotes(") can be removed.But unable to remove the double quotes in the sequential stage itself. In sequential stage, used Quote character property with the options of double quotes (") and (000). Tried both the options individually but unable to remove. Is there any way to remove in Sequential Stage ?
Need your help.
Thanks in Advance.
Using Convert Function in the transformer double quotes(") can be removed.But unable to remove the double quotes in the sequential stage itself. In sequential stage, used Quote character property with the options of double quotes (") and (000). Tried both the options individually but unable to remove. Is there any way to remove in Sequential Stage ?
Need your help.
Thanks in Advance.
Thanks & Regards
Madhuker
Madhuker