_x0001_ in all columns after inputting data

Question

Hey,

I am inputting 1 excel file.

However, when I input it, all cells in rows and columns get _x0001_ after data separated by space.

It doesn't exist in the actual input file.

001 is getting inputted as 001 _x0001_

US is getting inputted as US _x0001_

etc.

What's the issue?

philipmannering · Answer

@martinding  I don't understand why UTF-8 isn't the default..

martinding · Answer

Hi @ShantanuDagar,

This is likely to be a unicode character or ASCII/NonASCII issue, check your encoding in the input tool:

Depending on what is actually contained in your data, you can try a few different Code Page options.