Issue while exporting to CSV

neharao
Giga Contributor

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

2 REPLIES 2

Bryan Tay3
Mega Guru

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?


find_real_file.png


neharao
Giga Contributor

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.