Importing a CSV with | (Pipe Delimiter) into a custom table

[mattrom1]

I am trying to import a csv file that is a |  delimiter file but it is not showing up in the transform map correctly.

1. I went to System Import Sets > Data Sources

2. Added the CSV file and change the delimiter to |

3. Added the IST i created 

4. Submitted

5. Selected New for Transform map

All i see is the title for file in A1 in the source so, it has all the field titles in A1 Test | Test 1 | test 2 , etc

Since all the data in the excel is in column A, is there a way to have it split in servicenow or does this need to be manually done in excel first then upload to servicenow

[sachin_namjoshi · Accepted solution]

Please see solution below for importing file with delimiter

http://www.john-james-andersen.com/blog/service-now/importing-data-to-servicenow-with-custom-delimit...

Regards,

Sachin

[mattrom1]

I got it figured out from this..i didnt load data, which was what I was missing