Csv is a weird format. It has never been officially documented by Microsoft and still there is no hard standards for any library to follow. Especially around quoting strings and new lines (outside of unquoted ones which mark new row of a datatable)


It should work fine for both windows and unix new lines quoted between regular quotation mark ( " ).

If you want to get rid of new lines you can use regex regex replace with above expression, and replace with \t - which will be tab.