One Star

CSV file with two sets of double quotes for text enclosure

Hi,
we're dealing with a CSV file that has two sets of double quotes to represent text and I'm not sure how to set that in the tFileInputDelimited settings.
An example would be:
LOAN, ADDR1, NAME
1000, ""123 Main St, CA"", John Doe
I have tried """" and "\"\"" as the text enclosure but I get an error saying it's an invalid character.
 
1 REPLY
Moderator

Re: CSV file with two sets of double quotes for text enclosure

Hi,
Is your input file "UTF-8 with BOM"?
Have you tried to using EREPLACE as below in tJavarow
output_row.Column1 = StringHandling.EREPLACE(input_row.Column1,"\"","")?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.