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

deailes — Sat, 16 Nov 2024 02:07:13 GMT

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??

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

manodwhb — Thu, 18 Jun 2020 12:54:46 GMT

@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.

topic Re: Remove special character (160) from number (not string) in Talend Studio

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

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