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
extract Numeric values alone
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Thu Jul 10, 2008 6:18 pm
extract Numeric values alone
kishore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: