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,632 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...