Although ServiceNow has the capability of importing data in the CSV format using a custom delimiter, very few people know about it or understand how to get this to work. There is actually a great little wiki documentation segment on this, but you kind of have to know what you’re looking for in order to find it.
I’ve created a simple little YouTube video that demonstrates how you set up ServiceNow so that you can import a non-comma based CSV file.
This video demonstrates the creation of a CSV file that uses a semi-colon as the actual CSV delimiter. In the video we create a data source and set it up to consume that file. We then personalize the form layout for the data source record and at the CSV delimiter field that we can leverage to specify our special delimiter.
Nice video, its so simple…..
John, Your videos are awesome. Thanks!
Nice vid.
Hi John,
Thanks for the great video, it’s very helpful.
I have a slightly different requirement though.
I need to use multicharater delimiter e.g. !~!
The reason being, most single characters like comma and colon appear in my data.
I tried using !~! and some other two/three character delimiters but it doesn’t seem to be workin.
Could you please let me know if there is a way to make it work.
Thanks in advance!