Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Phone Number Cleanup - Replace non-numeric

Howdy!

I would like to be able to remove all non numeric characters from a phone number field.

Examples of values in my  Phone1 field

1) (999)999-9999

2 9999999999

3) 999-999-9999

Essentially, no matter what, i want to find and replace all (,),- with ''

Much thanks,

-DC

Tags (1)
1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Phone Number Cleanup - Replace non-numeric

try:

purgechar(Phone1, ')(-')

Hope this helps!

View solution in original post

2 Replies
jerem1234
Valued Contributor II

Re: Phone Number Cleanup - Replace non-numeric

try:

purgechar(Phone1, ')(-')

Hope this helps!

View solution in original post

Not applicable

Re: Phone Number Cleanup - Replace non-numeric

Awesome! Thank you

Not sure how i missed that looking through the QV guide