I'm looking for a DataStage function that recognize and extract the numeric character from a string. For example
I have a variable with this value:
"Ab12gh3s4"
The function have to returns "1234". I can created a function to do that but before I would know if it already exists a DataStage funtion able to do this type of data extraction.
I just tried, before reading your answer, the oconv function using "MCN" as second parameter and it works well. Is it the same? Anyway thank you for you help.
DSguru2B wrote:MCN with OCONV extracts only numbers. You can also look at the function DIGITS(). It does the exact same thing.
It's exactly what I want. I want to extract only digits from the input string, rejecteting all other character.
I saw the online DataStage manuals and now I know the differences between "MCN" and "MC/A". I have to use "MCN" for reformatting the input string without the alphabetic characters.