remove doble quotes from csv

JavierP2 — Tue, 25 May 2021 11:46:33 GMT

hi there,

I have a csv like,

"TEST"|"TEST1"|"TEST2"|

I do need to remove all the quotes, so final file should be.

TEST|TEST1|TEST2

I'm quite noob, but I think i'm in the correct way, I've created a tFileInputDelimited -> row1 (main) -> tFileOutputdelimited and i've added CSV options and text enclouse "\ "" but the resultant file it's not what I expect,

what i'm doing wrong? maybe is there an easy way to do this?

Thanks a lot!

Re: remove doble quotes from csv

Anonymous — Tue, 25 May 2021 11:57:03 GMT

On tFileInputDelimited, check the CSV option and set the text enclouse as """, uncheck the CSV option on tFileOutputDelimited.

Regards

Shong

topic remove doble quotes from csv in Talend Studio

remove doble quotes from csv

Re: remove doble quotes from csv