Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to resolve loading CSV data when SN automatically creates column with non-standard ASCII characters?

Todd O
Tera Guru

‎02-09-2017 04:22 PM

I'm loading data into SN tables by way of importing through data sources and import sets. I have plain csv files and I'm certain there are NO non-ASCII characters. However, when I create the data source and pick my csv file to auto map fiels for the transformation map, SN proceeds to create columns with non-ASCII characters as part of the name. See the image below. Why would SN have this behavior? It's messing up some other scripting I want to do where I want to match up the exact name from the CSV file. Thanks in advance.

Todd

find_real_file.png

Labels:
Preview file
85 KB
0 Helpfuls
  • 1,869 Views
5 REPLIES 5

Haikz
Tera Contributor

‎01-07-2022 05:18 AM

Hi

I had same issue and it got fixed after I converted file to UTF-8 (it was UTF-8-BOM) encoding.

There is also a support case on same topic: Importing CSV shows the error "data contains Y columns, expected Z" - Support and Troubleshooting (s...