Remove non-numeric charcaters from a string

[_AnonymousUser]

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 ?


 

[gorotman]

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

[_AnonymousUser]

Exception in component tMap_1
java.lang.NullPointerException

[gorotman · Accepted solution]

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]", "" )

[_AnonymousUser]

Works fine, thanks.

[gtaware]

Just I tried like below and it worked out : 

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