extract Numeric values alone
Posted: Wed Aug 27, 2008 3:10 am
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
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