Recognizing phone numbers

[miro_kopecky]

Hi guys, I am pretty new with qlik sense and I have to write script for recognizing if the number from some text is a phone number from a certain country or not.
I think it could be based on prefixes. If anyone could help me i would be greatful.
Thanks in advance.

[YoussefBelloum]

Hi,

it depends on how and where exactly the phone numbers are written in a field, sometimes it is better to clean the source before trying to create a transformation script..

would you be able to share with us a portion from your phone_numbers field ?

[miro_kopecky]

I have som text and in that text are some numbers and these numbers could be some phone numbers and i need to write a script that will recognize if this number is a phone number and ig it is from czech republic

czech phone numbers have prefix +420 and looks like this (+420) 123 456 789. The first three digits (123) in czech republic could be only 601 to 608, 702 to 705. for example 603 354 684

[DavidŠtorek]

Hi,

I am not sure if you are talking about phone number in general or for some specific company or group of people. But if in general you are not right about that restrictions regardings first three numbers.

Does this text come from some form, where people fill in phone numbers or just from some long text field? I am asking if there is some given format or not (like prefix will be allways in brackets etc.). Does text have given length, is it concatenated from more fields? Are there allways spaces between numbers?

[kaanerisen]

Hi Miroslav,

Check this thread. Thanks to swuehl , he published a really good and solid solution for this

Regular expression [A-Z] *

[JustinDallas]

I don't think RegEx exists in QlikSense, so you will have to do it outside of QlikSense (SQL query and such).

How to work Regular Expressions in Qlik Sense?