How to Remove Special Character

One Star

How to Remove Special Character

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
One Star

Re: How to Remove Special Character

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

Re: How to Remove Special Character

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