REGEX_MATCH() -- Example..

Source is a Flat File.  The Name Columns Contain Non-Alphabetic Character at any Position Like

  (0-9) (!@........so on) . We need to separate the data.

Names
Anudeep
Rajes4h
Pravee@n
Ra5mesh
Kuldeep

$reddy

Maya_

Target should be loaded as..

Target1                 Target2    

Anudeep                   Rajes4h
Kuldeep                     Pravee@n

                                    Ra5mesh

                                     $reddy  

Solution

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

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

-- Ram