Remove special character (160) from number (not string)

[deailes]

Hiya

I have a 6 digit number copied from webpages in an excel document i am importing. It has trailing special character at the end of the number on some of the entries. ie '123456 '

I can see how to remove special character from a string in the tMap using:

row1.inputField.replaceAll("\\D", "") 

but how would i achieve the same thing if my input file column is a number and i want to keep the column as a number (int).  Do i have to convert it to string first and then back again??

[manodwhb · Accepted solution]

@deailes , first you need to read as a string from the file in tfileinputdelimitted and then tmap you can convert .sting to int after removing special characters.