Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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 (3)
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.