Mathematica 11.2 Import Statement Produces Errors & Truncates CSV Data Created in 11.1
The CSV importer was completely rewritten in version 11.2 in order to improve performance and fix a number of long-standing issues. For example, if you imported your csv files back in version 11.1 and din't know to specify a CharacterEncoding option, you would find that all special characters were corrupted.
Also, if you tried to open your 11.1-generated files in a spreadsheet (I used libreoffice), they would only open with 34 rows and lose some data. This is because earlier versions did not quote double quotes inside individual cells, so Missing["Uncertain"] would appear malformed. I don't think that behavior was "wrong" b/c CSV is a somewhat underspecified format, but it certainly isn't the currently dominant standard. I don't recall all the details beacuse I was only very peripherally involved, but this is certainly something which was considered carefully.
Version 11.2 properly quotes double quotes and now follows the standard of fairly agressively using quotes in any "text" field. You can get it to import old CSV files by manually adding the option "TextDelimiters"->""
. Files generated in 11.2 should import fine into older versions, but will likely have doubled quotes inside of text strings due to the new quoting behavior. (Meaning, in particular, ToExpression
won't work unless you eliminate the doubled double-quotes first.)