Replacing special character and non numeric and alphabets in a column

[Anonymous]

Hi All 
I want to remove the special character and alphabets and non-Numeric Record in a particular column lets say mobile no 
EG: Input
Mobile,ID
123,1
123&,2
L.123,3
ABC,4
124,5
?,6
@,7
$,8

First Output should Contain all the 8 record 

Mobile,ID
123,1
      ,2
      ,3
      ,4
124 ,5
      ,6
      ,7
      ,8
Second Output Should be
Mobile,ID
123&,2
L.123,3
ABC,4
?,6
@,7
$,8

How can i do this
I Can able to get the First output  as i Mentioned above and
also i can able to get the second output but not the complete one what output i am getting is 
Mobile,ID
123&,2
L.123,3
ABC,4
but i want the second output i am using T-Map because my scenario is like that

Regards
NJ

[Anonymous]

Hi,
You can use regular expression
in a tJavaFlex component :

   String var = null;
   var = row<in>.<valuename>;
    p = Pattern.compile("[a-zA-ZÂ]+");//or other character you need;
    m = p.matcher(var);
    var= m.replaceAll("");
row<out>.<valuename> = var;

[Anonymous]

Hi 

My Problem is i want to filter it in the tmap only