CSV parsing data incorrectly (comma in quotes used a a delimiter)

[Rafeski]

Hi,

The attached file is taken from the US flight records that is openly available - its a great source for large files. However, when I set the parser to use comma delimited, the parser appears to take a comma that is INSIDE quotes as the field delimiter as shown in the screenshot.

The file contains:

,"Los Angeles, CA","CA","06"

whereas the comma after Angeles (that is inside the quotes) is taken as the field delimiter, not the one after the closing quote.

I have tried all sorts of settings for this - has anyone got any suggestions?

Please?!

Thanks

[Anonymous · Accepted solution]

Set the escape char as "\"" and try again.

 

[Rafeski]

Hi Shong,

It works a treat! Thank you!