Problem reading csv file with quotes

My CSV file contains these kind of information in one column "FS Peru, IL"
Somehow the csv node is not reading it properly.
How can I fix this please so the csv node will also read quotes as one column and not 2?

Can you share at least a few lines of the file so we can test. Thanks

@dceejay I found the problem. When the csv is exported from excel it creates problem with the csv node reading the quotes, though when I use the fastcsv it reads it properly.

When the CSV is created from scratch and not from excel the csv node works without problem. weird.

Well we still can't investigate/fix it without an example.

A simple test with a csv exported from Excel works just fine

test.txt (92 Bytes)

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.