CSV file with two sets of double quotes for text enclosure

[_AnonymousUser]

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.
 

[Anonymous]

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