Need a way to quote or remove newlines in exported CSV files. Using LibreOffice 4.3.5.2
Is there a way to search/replace spreadsheet cells that have multiple lines?
If the original spreadsheet has multiple lines, the CSV file will look like
A1, “B1 stuff”,C1
A2, “B2
stuff”,C2
A3,“B3 stuff”,C3
etc.
this is difficult for text based tools to work with
the xlsx2csv php python script has a quoting option so the output looks like:
A1, “B1 stuff”,C1
A2, “B2\nstuff”,C2
A3,“B3 stuff”,C3
would be nice to do this directly in save as