ReadFile Error

The engine.
Post Reply
jdtoellner
Posts: 71
Joined: Mon Aug 01, 2016 9:45 pm

ReadFile Error

Post by jdtoellner »

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.
shooltz[BayesFusion]
Site Admin
Posts: 1417
Joined: Mon Nov 26, 2007 5:51 pm

Re: ReadFile Error

Post by shooltz[BayesFusion] »

Can't read file, Unexpected endline in the quoted string
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.
Post Reply