Mathematica does not seem to handle CSV files containing line breaks. A specification of CSV at http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm provides details on how line breaks should be encoded. When integrating with other systems I encounter this encoding. Mathematica does not handle the line breaks correctly.
Test input:
Conference room 1, "John,
Please bring the M. Mathers file for review
-J.L.
",10/18/2002
Mathematica Notebook Test Case:
In[39]:= csv=Import["~/Downloads/test.csv"]
Out[39]= {{Conference room 1, "John,},{Please bring the M. Mathers file for review},{-J.L.},{",10/18/2002}}
In[40]:= Length[csv]
Out[40]= 4
In[41]:= csv[[1]]
Out[41]= {Conference room 1, "John,}
In[42]:= csv[[2]]
Out[42]= {Please bring the M. Mathers file for review}
In[43]:= csv[[3]]
Out[43]= {-J.L.}
In[44]:= csv[[4]]
Out[44]= {",10/18/2002}
Test system: "11.1.1 for Linux x86 (64-bit) (April 18, 2017)"
Attachments:
