REG_EXTRACT - Extract a Number From String in Informatica

The following regular expression extracts first matched number in sequence
REG_EXTRACT(employee,'(\d+)',1)

employeeOutput
No9ing9
Test789data789
TestEmpty String
Test67ab89a67

In the last row only 67 is extracted, if you want to extract all the numbers from a string data use REPLACE_CHR or REG_REPLACE