Describe the issue/error/question
From a CSV file i use
Spreadsheet File to read the content of the csv and convert it to json. The
: cause a break line problem. See screenshot :
And when using a node after that to use the json data, i can’t get the data.
CSV file : https://tmpfiles.org/30854/csv2.csv
What is the error message (if any)?
View message above
Please share the workflow
Share the output returned by the last node
Information on your n8n setup
n8n version: 0.192.0
Database you’re using (default: SQLite): Default
- Running n8n with the execution process [own(default), main]:
- Running n8n via [Docker, npm, n8n.cloud, desktop app]:
sorry to hear you are having trouble. When I try to download your csv I am getting
404 NOT FOUND. Can you upload your csv again?
I just tried out your csv file and the file content itself seems to be corrupted. It’s true that the csv is parsed incorrect.
Looking at the file itself, are all the
Banner : lines supposed to be there?
There also seems to be a lot of unneccessary whitespace.
I have to say I’ve never seen a csv like that so I am unable to help here. Are you able to work with more regular csv files? Am I missing something?
The csv file comes straight from F-Secure Elements VM API
I have no other way to get the CSV.
It’s probably a problem with their API then