How do I change the CSV file delimiter from a comma "," to a carrot "^"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2016 09:52 AM
Hi. We are exporting data as a CSV (customer requires it) but we can't use a comma as one of the fields is a comments field which is full of commas. I want to use a carrot ^, since this is not a common character.
how do I change or set the delimiter character?
Kris
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2016 07:29 AM
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2016 07:56 AM
It's a "caret"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2016 06:52 AM
This might help, which I just posted CSV Primer & Troubleshooting Tips
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2016 10:54 AM
OK. So 2 questions.
1. Why can't I just replace the comma with a caret? That would be the simplest way.
2. Where/when does this run? You say Script Includes... I'm still new to Service Now, so if I create it there, it will always run when I do an CSV export?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2016 11:00 AM
1. If your data happen to contain a caret, although rare, it'll cause issues.
2. How are you generating your CSV export?
