topic tFileInputDelimited with single text qualifier in Talend Studio

tFileInputDelimited with single text qualifier

_AnonymousUser — Sat, 16 Nov 2024 12:39:28 GMT

Hi,
I'm having problems with a CSV file that contains a double quote inside the a field enclosed by double quotes.
Ex:
"Data1","Data2","Data" 3"
Is there a quick and easy way to get around this issue using when using a tFileInputDelimited.
Thanks in advance.

Re: tFileInputDelimited with single text qualifier

Anonymous — Wed, 28 Sep 2011 03:19:58 GMT

Hi
Read it as a normal text file separated by ",", remove the double quote " on tMap. For example:
row1.columnName.replaceAll("\"","")
Best regards
Shong

Re: tFileInputDelimited with single text qualifier

_AnonymousUser — Wed, 28 Sep 2011 15:09:02 GMT

If I'm understanding this correctly this would remove all quotes and I want to preserve the inner quote.
Thanks

Re: tFileInputDelimited with single text qualifier

janhess — Thu, 29 Sep 2011 10:14:45 GMT

When I've had this sort of problem, I take the data delimited by the ',' replace the first ", reverse the string using a function, remove the first quote again and reverse the string again. That leaves everything else in the string intact.