Hi my source data is like
Columnname
aaa111
bbb222
ccc333
But i want to split the data alphabets in to 1 target and numarics in to 2 target....
Regards
How to split the alphabets and numarics
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Mon Jun 28, 2010 11:24 pm
- Location: seepz
How to split the alphabets and numarics
NARESHKUMAR
Probably the simplest logic would be two derivations in a transformer, each using the Convert() function. One converts any alpha to an empty string "", the other converts any numeric to an empty string "". So long as your live data meets the format you show in your example, then that should meet your requirements.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.