Reformat, Sort and Add Column changes CRLF to LF

BdR76 / CSVLint

CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.

GNU General Public License v3.0

151 stars 8 forks source link

Reformat, Sort and Add Column changes CRLF to LF #91

Closed rdebath closed 3 weeks ago

rdebath commented 3 weeks ago

Even if you untick all the options in "Reformat Data" the process removes all CR characters from the file.

This upsets several Windows importers including (sometimes) Excel. If Excel has a multiline value in a column it'll use "LF" for the lines in a column and "CRLF" at the end of a line.

BdR76 commented 3 weeks ago

Thank you for posting this issue. You are right, the same thing happens for Sort and Add column. I can't believe I never noticed this.

I've fixed it and it will be available in the next release. In the meantime you can download the beta (β3) version of the DLL here

BdR76 commented 2 weeks ago

I felt like this issue was important enough for an update, so I've released a new version v0.4.6.7 that includes this fix