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
RE:handle alphanumeric values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
Are any other input characters, such as separators, likely?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: RE:handle alphanumeric values
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: RE:handle alphanumeric values
1. Not in parallel jobs.rajeshb wrote:U CAN USE DIGIT TRANFORMS
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: RE:handle alphanumeric values
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().
Use to get rid of numeric values and vice versa.
Code: Select all
Convert('0123456789','',InputColumn)
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson