CSV file with column value with double quote

naren6876 · Post by **naren6876** » Mon Dec 13, 2010 10:13 pm

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,

ray.wurlod · Post by **ray.wurlod** » Mon Dec 13, 2010 10:18 pm

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)?

chulett · Post by **chulett** » Tue Dec 14, 2010 7:15 am

And then *if* you still need to remove the quotes, do so after you read it.

madhuker · Post by **madhuker** » Wed Dec 22, 2010 5:14 am

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.

chulett · Post by **chulett** » Wed Dec 22, 2010 7:23 am

Double-quotes inside a field? No. Well, unless you consider leveraging an O/S command like awk from the Filter option in the stage to be that. Then yes.