topic Re: Remove non-numeric charcaters from a string in Talend Studio

Remove non-numeric charcaters from a string

_AnonymousUser — Wed, 18 Jan 2017 08:13:17 GMT

Hi,
In want to keep only numeric (0 to 9) characters from a string.

I use the following code, which doesn't work.
(row2.phone_id).replaceAll( "[^\\d]", "" )
Which code should I use ?

Re: Remove non-numeric charcaters from a string

gorotman — Wed, 18 Jan 2017 09:29:46 GMT

Hi, your code works (I tested it with TOS 6.2.1, tJava component and string "AAA12345BBB67890CCC").
Do you have errors or unexpected result?

Re: Remove non-numeric charcaters from a string

_AnonymousUser — Wed, 18 Jan 2017 10:10:50 GMT

Exception in component tMap_1
java.lang.NullPointerException

Re: Remove non-numeric charcaters from a string

gorotman — Wed, 18 Jan 2017 10:21:15 GMT

ok , probably input flow has null values in phone_id columns....may be? Is null valid for you?
You can't use replaceAll method on a null istance (of row2.phone_id).
test before call:

row2.phone_id==null?"":row2.phone_id.replaceAll( "[^\\d]", "" )

Re: Remove non-numeric charcaters from a string

_AnonymousUser — Wed, 18 Jan 2017 10:30:44 GMT

Works fine, thanks.

Re: Remove non-numeric charcaters from a string

gtaware — Thu, 21 Nov 2019 06:14:22 GMT

Just I tried like below and it worked out :

row7.data.substring(11,19).replaceAll("[a-zA-Z]", "")