HI,
I have input string as alphanumeric string which is ex: xxyyzz1212xxx.
I want o/p like 1212.
we can do this in Server job using oconv. can we do this in parallel jobs.
can any one help me?
AlphaNumaric string
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
convert() can do the trick.
this will remove alphabets from the input string and you will be left with numeric values.
EDIT : added code and line below it.
Code: Select all
convert(<all alphabets>,'',<input column>)
EDIT : added code and line below it.
Last edited by priyadarshikunal on Fri May 29, 2009 10:25 am, edited 1 time in total.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)