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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

how to remove special characters from phone number

Hello everyone

How can i remove the special character from phone number and add '0' in the start of the phone number 

i.e  334-55678 ( answer  should be like '033455678')

Thanks in advance🙂

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

'0'&Purgechar(PhNo, '-')

View solution in original post

1 Reply
tresesco
MVP
MVP

'0'&Purgechar(PhNo, '-')