topic How to Remove Special Character in Talend Studio

How to Remove Special Character

Anonymous — Fri, 13 Feb 2015 23:24:37 GMT

Hi Team,
can any one help me how to remove special characters from a string under a particular column.
I want to read complete string and replace "(" with "".
I have a data like below
CELL_PH_NO
(999)-000-1111
999 222 1111
now i wan output as
CELL_PH_NO
999-000-1111
999-222-1111

Thank you so much in advance

Re: How to Remove Special Character

Anonymous — Sat, 14 Feb 2015 19:17:54 GMT

Hi,
you can use replaceAll
string.replaceAll("(","");
Regards,
Anu

Re: How to Remove Special Character

Anonymous — Mon, 16 Feb 2015 14:02:24 GMT

Hi ,
row1.CELL_PH_NO.replaceALL("","")
Regards,
Kumar