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
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.