Export as CSV : some fields nave new lines in which breaks the CSV

[cjohnsonuk]

I'm using the "export" action on Accounts to create a file with all the data in for another project. However some of the fields (eg address fields and some of our custom fields) have new line characters in them so the exported file, although it has a CSV extension does not appear to be a valid file format. Some fields are encapsulated by double quotes, some are not. All are using ; as a delimiter. Are there options to change this export format to make all fields encapsulated by " and replace the new lines with a "safe" alternative?

[yuri]

It's a valid CSV. Fields are enclosed if there are line breaks.

Re-open an exported file in any spreadsheet app and re-export with needed parameters.