How to separate only string data into one target and numeric data or special character data into second target in informatica ?

Example: suppose my Source is a Flat File and having with Alphabetic Character and Contain Non-Alphabetic Character at any Position Like

  (0-9) (!@........so on) . We need to separate the data,while loading into targets

Names 

XXXX 

YYYYY4Y

ZZZZZZ@K

AAAAAA

BBBBB

$CCCCC

DDDDD_

Target should be loaded as..

Target1                 Target2    

XXXX                   YYYYY4Y

AAAAAA              ZZZZZZ@K

BBBBB                  $CCCCC

       $DDDDD_  

Solution:-

i).Use the Informatica data comparision function REGEX_MATCH( ) to achieve this..

ii).Use Filter Condition as  REG_MATCH(Names,'^[a-zA-Z]+$')

Thanks,

Hari