How to extract number from a string in Informatica?

Question

I want to extract the number(0-9) from the string. e.g. if src is *Ax456*&56 then dst should be 45656.

Answer 1

Try something like this

REPLACECHR(0, REG_REPLACE(COLUMN_NAME, '[^0-9]', '/'), '/', NULL) 

Comments

thanks it is working , i am able to get only number in string ...

Answer 2

replace all other characters with an empty string. Below syntax will help you -

REG_REPLACE(COLUMN_NAME, '[^0-9]', '')