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.