Actions
Defect #41434
openCSV import fails with error for quoted fields containing newlines and CRLF line endings
Status:
New
Priority:
Normal
Assignee:
-
Category:
Importers
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Affected version:
Description
When you attempt to import the attached CSV file (test.csv), the following error message is displayed:
The file is not a CSV file or does not match the settings below (Unquoted fields do not allow new line <"\r\n"> in line 1.)
This error occurs when the CSV file contains values with newline characters ("\n") inside double-quoted fields, and the lines end with DOS-style line endings ("\r\n"). If the file uses UNIX-style line endings (\n), the error does not occur.
This type of CSV file can be generated by Microsoft Excel when cells contain line breaks.
Files
No data to display
Actions