Removal of any non-numeric character

akarsh · Post by **akarsh** » Mon May 19, 2008 1:29 am

Hi All,
I want to remove any non-numeric character from a string and the out put should have only numeric characters.please tell me hoe i can do this.
eg: input - AB123, o/p - 123

Thanks,
Akarsh

ArndW · Post by **ArndW** » Mon May 19, 2008 1:35 am

DataStage PX has no builtin functions to do this. You can either write your own BuildOp to do this, or use a BASIC transform stage and the OCONV() function.

ray.wurlod · Post by **ray.wurlod** » Mon May 19, 2008 4:19 pm

Welcome aboard. This question has been asked, and solutions offered, in the past. Search is your friend.