Page 1 of 1

AlphaNumaric string

Posted: Fri May 29, 2009 9:32 am
by jagadish9
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?

Posted: Fri May 29, 2009 9:55 am
by miwinter
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.

Posted: Fri May 29, 2009 10:10 am
by priyadarshikunal
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.

Posted: Fri May 29, 2009 10:13 am
by chulett
:idea: 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.

Posted: Fri May 29, 2009 12:47 pm
by jagadish9
Convert is working for this.....


Thanks for the Help