_x0001_ in all columns after inputting data

[ShantanuDagar]

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?

[martinding]

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.

[PhilipMannering]

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