Hi everyone, GOAL: I am trying to upload this CSV file to the CSV Parser: UploadToServer.csv Set Up I have a very basic set up, I am sending a CSV file from a FileMaker server to Make via a mailhook. [04-11-2024-00.34.56] The test file has 12 rows and only two records: [04-11-2024-00.41.52] …

Welcome to the Make community! Your CSV does not have correct line terminators. So, in your CSV data field, paste this: {{ replace(toString(1.data); "/[\r\n]+/g"; newline) }} Replace Data with your webhook attachment variable. [Screenshot_2024-04-11_183206] Output: [Screenshot_2024-04-11_183…

Thank you very much @samliew ! You are correct and your solution works. After some research, I learned that when FileMaker exports as CSV it uses a carriage return at the end, but the CSV Parser is looking for a linefeed. Thanks again!

There are three types of line terminators, CRLF, LF, and CR. CR: Carriage Return (also known as \r) LF: Line Feed (also known as \n) CRLF is just both together: \r\n You can check with FileMaker to see if the line terminators can be customised to use “LF”.

@samliew I have a similar problem as Fred_S. I also import a .csv from a HTTP request and parse it through a Text parser to remove the first 2 lines of the .csv. Im also this error: Number of columns on line 1 does not match header. The output is also just 1 Bundle. Tried to use the code you pro…

Welcome to the Make community! That looks like a new question, could you please create a separate topic for this? While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic. It helps other community users to respond to your query, and keeps our spac…

Thanks. Done. Maybe you can pitch in. Thanks [image] .csv file parsing error : Number of columns on line 1 does not match header Questions & Answers I’m importing a .csv from a HTTP request and parse it through a Text parser to remove the first 2 lines of the .csv. I’…

Text Parser error with basic CSV

Questions

ViolentNomad78 April 22, 2024, 11:06am 7

Thanks.
Done.
Maybe you can pitch in.
Thanks

Topic		Replies	Views
Error Parsing a CSV File Questions http , csv , error , parse	8	2509	June 19, 2024
.csv file parsing error : Number of columns on line 1 does not match header Questions regular-expressions	15	1653	April 23, 2024
Parse CSV Number of columns on line 1 does not match header Questions error	0	187	August 29, 2024
CSV Delete/filter rows before parsing Questions csv	5	1092	October 5, 2023
CSV Parse Issue Questions google-sheets	3	1023	August 22, 2023

Text Parser error with basic CSV

Related topics