I discovered an interesting thing when reading a CSV file with ReadFile. I got the following error:
Can't read file, Unexpected endline in the quoted string
I created the CSV file with Excel. Some of the cells had multi-line data. When I changed the data to single-line the error went away.
ReadFile Error
-
- Site Admin
- Posts: 1417
- Joined: Mon Nov 26, 2007 5:51 pm
Re: ReadFile Error
The error message is caused by quoted string containing a newline character. As you've mentioned in your email, there were some cells with newline characters in the original Excel file. The CSV parser in SMILE assumes that newline character is always at the end of the line, regardless of the quotes being used.Can't read file, Unexpected endline in the quoted string