Cannot find what you need? - Click here to contact us

Close




Commas in my CSV export/report are effecting my data format and order

Commas in any of your text fields are no problem in a CSV export. In your Report Templates just surround your data tags with double quotes to tell Excel to keep everything between the double quotes in one column even if it has commas. Please see our CSV export sample report for how your report should be. Or better, use our sample and just modify it rather than creating your own.


Bad example of report tags not enclosed...

{{SI-E-Title}},{{SI-E-Notes}}...


Good example of report tags that are enclosed and safe if the data may contain commas...

''{{SI-E-Title}}'',''{{SI-E-Notes}}''...
Last updated, 8 March 2017, 11:39




Leave a public comment (Login required) or click here to contact us for support




Still need help? Contact Us
Schedule it
/faq/10700/commas-in-my-csv-export-report-are-effecting-my-data-format-and-order
Join Us - Live Webinar
...
Close
 
Help Topics
Search
Contact Us