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

cjohnsonuk

Junior Member

Join Date: Oct 2017

Posts: 26
Share

Tweet
#1

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

10-01-2018, 03:46 PM

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?
Tags: None
yuri

Member

Join Date: Mar 2014

Posts: 8455
Share

Tweet
#2

10-01-2018, 04:35 PM

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.

Last edited by yuri; 10-01-2018, 04:37 PM.

If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.
Comment

Comment