Introducing Radical.sh
Forget Code launches a powerful code generator for building API's
REG_EXTRACT - Extract a Number From String in Informatica
The following regular expression extracts first matched number in sequence
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
- REG_EXTRACT(employee,'(\d+)',1)
| employee | Output |
|---|---|
| No9ing | 9 |
| Test789data | 789 |
| Test | Empty String |
| Test67ab89a | 67 |
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