Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I really appreciate your response.
How can I load my Descriptions from the QVD file instead of loading from Inline?
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.