Page 1 of 1
RE:handle alphanumeric values
Posted: Tue Aug 03, 2010 11:03 pm
by manikumar
i have a input
col
----
aa123
34bbb
567kk
i want two output like
output1
col
----
aa
bbb
kk
and second output like
col
----
123
34
567
Posted: Tue Aug 03, 2010 11:14 pm
by ray.wurlod
Transformer stage using Convert() functions to remove the numeric characters (for one output) or alphabetic characters (for the other output).
Are any other input characters, such as separators, likely?
Re: RE:handle alphanumeric values
Posted: Wed Aug 04, 2010 1:07 am
by rajeshb
manikumar wrote:i have a input
col
----
aa123
34bbb
567kk
i want two output like
output1
col
----
aa
bbb
kk
and second output like
col
----
123
34
567
U CAN USE DIGIT TRANFORMS
Re: RE:handle alphanumeric values
Posted: Wed Aug 04, 2010 1:46 am
by ray.wurlod
rajeshb wrote:U CAN USE DIGIT TRANFORMS
1. Not in parallel jobs.
2. Please do not "shout" (use all upper case) when posting.
3. The second person personal pronoun in English is spelled "you". U is one of our posters.
Re: RE:handle alphanumeric values
Posted: Wed Aug 04, 2010 7:23 am
by manikumar
Thanks for responding .can u give me a syntax of entire function i know convert function.but i am not getting in this scenario how to use conver().
Posted: Wed Aug 04, 2010 7:33 am
by kris007
Use
Code: Select all
Convert('0123456789','',InputColumn)
to get rid of numeric values and vice versa.