Issue while exporting to CSV
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2017 06:54 AM
Hi all,
I want to export asset table (alm_hardware) data. I have a field by name "comments" which has values with line breaks(\n). For example see below:
Comments : abccd
EFGH
IJKLM
When I am trying to export to CSV i have issues and the values are not comming up in same column. But when i try to export it to excel it works fine. But my requirement is to do with CSV.
Kindly let me know how to proceed on this. Should i write a background script to remove the line break space and then try to export or is there any option in export settings ?
If any script to be written could you please help me with the same.
Thanks,
Neha

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2017 04:19 PM
hi Neha,
I had just tried the export to CSV in my instance and verified that the multiple line are being handled by having double quote for column values.
this is an out of the box feature.
May i know which version of ServiceNow you are running?
Have you tried open the csv file in a text editor and verify the multi line being quoted with double quote?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2017 01:31 AM
Hi Bryan,
Thanks for the response .The issue got fixed now. It was because of excel version. It is working fine with the new excel version 2016.