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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Dulguun1998
Contributor
Contributor

Extract Phone Numbers from description

I need to extract phone numbers from the transaction description.  

My description  includes: 

TRF=001646195032-**********XX8741-99072741

TRF=001646187958-**********XX2062-ATM1098>UB 99995075À

99296772 ÕÀÀÍÀÀÑ: 020000 ÌßÃÌÀÐѯÐÝÍ ÑÀÍËÈÍ

My goal is to extract 8 digits phone numbers () from this description without the other unnecessary numbers. 

I tried keepchar(DESCRIPTION,'0123456789') this method but my phone numbers keep mixing up with other numbers.

How can i extract only phone numbers 

Can someone help me with this? I really appreciate it. 

Labels (2)
11 Replies
Dulguun1998
Contributor
Contributor
Author

I really appreciate your response. 

How can I load my Descriptions from the QVD file instead of loading from Inline?  

Dulguun1998
Contributor
Contributor
Author

Thank you for your response. 

Your script works perfectly except this Description ( EB-14:19:01 (89789086) - {mb:ps}88483240 ).

My output should be this number 88483240 but instead, my output showing me this 9789086). 

How can I fix this 

I really appreciate it.