RE:handle alphanumeric values

[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

[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?

[rajeshb]

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

[ray.wurlod]

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.

[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().

[kris007]

Use

Code: Select all

 Convert('0123456789','',InputColumn) 

to get rid of numeric values and vice versa.