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.
Hi
Read it as a normal text file separated by ",", remove the double quote " on tMap. For example:
row1.columnName.replaceAll("\"","")
Best regards
Shong
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.
