Export Sets - Delimiter change
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 08:41 AM - edited 03-01-2023 09:16 AM
Hello,
For Export Sets, is there a way to change the delimiter from comma to a different character like a pipe?
Thank you,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2023 01:53 PM
Hi Eric,
What do you mean by "Export Sets"? and do you have steps to reproduce? The Export features (records and update sets) use XML.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2023 03:10 AM
Hi Bert,
I am referring to System Export Sets -> Administration -> Export Sets. The Format field allows for several options, one of which being CSV. However, I have been asked for a scheduled export where the data uses a pipe delimiter instead of comma.
I don't believe there is an option to change this especially since a lot of the older community posts agree, but wanted to see if anything had changed.
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2023 06:23 AM
Hi,
you can't. servicenow sets the delimiter as comma (,) for the columns.
Mark Correct if this solves your issue!
Thanks and best regards
Giuseppe Giannotta