remove doble quotes from csv

[JavierP2]

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!

[Anonymous]

Hi

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

Regards

Shong