I’m importing (from FTP drive) a CSV that is created each night by our accounting system. I need to split that CSV down to several other smaller csv’s.
When i execute the scenario, i get an error that the “Number of columns on line 1 does not match header” but on the face of it the columns look correct.
I tried opening the csv in Libre Office Calc and saving it - made no other changes, and the file imports correctly and scenario runs without issue.
What can cause the parse CSV module to think the number of columns is incorrect? I’ve attached the original file.
Thanks.
SPE_Product_Update.csv (982.4 KB)