Data Stage function extracting only numbers

Umbix62 · Post by **Umbix62** » Thu Aug 17, 2006 9:23 am

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.

Thank you everybody

Umberto

kaps · Post by **kaps** » Thu Aug 17, 2006 9:27 am

Use MC/A function with oconv.

Umbix62 · Post by **Umbix62** » Thu Aug 17, 2006 9:37 am

kaps wrote:Use MC/A function with oconv.

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 · Post by **DSguru2B** » Thu Aug 17, 2006 9:39 am

MCN with OCONV extracts only numbers. You can also look at the function DIGITS(). It does the exact same thing.

chulett · Post by **chulett** » Thu Aug 17, 2006 9:41 am

DIGITS is a Transform, not a function. Makes the whole 'MCN' thing easier to understand in the job.

DSguru2B · Post by **DSguru2B** » Thu Aug 17, 2006 9:48 am

Actually thats what i meant to say, a Transform function. I dont know why i categorize everything as a 'function'

Bound by habit i guess.

Umbix62 · Post by **Umbix62** » Thu Aug 17, 2006 9:56 am

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.

Thank you very much

Have a nice day

Umberto