extract Numeric values alone

[kishorebhulokam]

Hi All,



In one off my source Field (CODE) I have values like (eg: 956,1637,P O BOX288, PO box 1162,-,.,.PO,0,0001,0002...) now my task is to extract only numeric values and load into target table is there any Function in Data stage to do this? And my source values are not fixed length.

Thanks in Advance

[Jasti]

use Num() function..

[svga]

Hi,

Use Oconv function

Syntax: Oconv(Field,"MCN")

[ray.wurlod]

Use DIGITS transform (which is a meaningfully named way to invoke the "MCN" conversion).