Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi,
you can use replaceAll
string.replaceAll("(","");
Regards,
Anu
Anonymous
Not applicable
Author

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