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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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, '-')