How to split the alphabets and numarics

nareshketepalli · Post by **nareshketepalli** » Thu Mar 10, 2011 4:55 am

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

jwiles · Post by **jwiles** » Thu Mar 10, 2011 9:36 am

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,