Hi All,
My requirement is to Populate only number for a column which can contain alphanumeric.The length of Column is 24 and dattype is Varchar.number and alphabets can come at any place.
Ex..if data is coming like hfkhfh12hje4344jbd4j then i need to populate only 1242444. or if input data is hjdghj342475jfhjf8 then i need to populate 3424758.Is there any inbuilt unction in datastage to do this.
Can anyone pleas help me on this and suggest me what i can do for this???Please help me.
Thanks in Advance.
How to Exract only number from alphanumeric
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Oconv() function is not natively available in parallel jobs. Oconv() with "MTS" is for working with Time data. Had the OP wanted to use Oconv(), the second argument would be "MCN" rather than "MTS", and it would be necessary to use a BASIC Transformer stage (or a server Transformer stage in a server shared container), either of which would have negative implications for throughput.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.