DSXchange

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,

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

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

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.

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.