AlphaNumaric string

jagadish9 · Post by **jagadish9** » Fri May 29, 2009 9:32 am

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?

miwinter · Post by **miwinter** » Fri May 29, 2009 9:55 am

You could employ a BASIC transformer stage to access the same logic as you would use in a server job to achieve it - note the potential performance implication however.

priyadarshikunal · Post by **priyadarshikunal** » Fri May 29, 2009 10:10 am

convert() can do the trick.

Code: Select all

convert(<all alphabets>,'',<input column>)

this will remove alphabets from the input string and you will be left with numeric values.

EDIT : added code and line below it.

chulett · Post by **chulett** » Fri May 29, 2009 10:13 am

If you are going to suggest something, please break the Magician's Code and explain how to make the 'trick' work at the same time.

jagadish9 · Post by **jagadish9** » Fri May 29, 2009 12:47 pm

Convert is working for this.....

Thanks for the Help