REGEX to extract phone number from Text

How To
1

Hi Makers,

I’m trying to extract a phone number from a text.

I tried multiple Regular Expressions but it does not match any pattern.

Here is one of the Regex I used : /+?\d{1,4}?[-.\s]?(?\d{1,3}?)?[-.\s]?\d{1,4}[-.\s]?\d{1,4}[-.\s]?\d{1,9}/g

I want to retrieve this kind of phone number from a text :

+32484487694
0484487694
0484 48 76 94
0032484487694

Is there anyone who could help me please ?

Thanks !

Capture d’écran 2022-09-22 à 14.35.39
Capture d’écran 2022-09-22 à 14.35.392630×636 80.7 KB

Capture d’écran 2022-09-22 à 14.35.45
Capture d’écran 2022-09-22 à 14.35.45908×1536 133 KB

Capture d’écran 2022-09-22 à 14.35.50
Capture d’écran 2022-09-22 à 14.35.501660×872 110 KB

1 Like
2

Try this.

Lots of great resources to help you there.

2 Likes
3

Thanks I will a look.

4

I found this regular expression on regex101: Regex for telephone numbers all over the world

I did some test on their website and the expression seems to work out (see screenshot). When I copy/past it into the text parser, it does not find anything. How come ?

Thanks for your help.

Capture d’écran 2022-09-22 à 15.10.14
Capture d’écran 2022-09-22 à 15.10.141564×758 97.7 KB

Capture d’écran 2022-09-22 à 15.10.24
Capture d’écran 2022-09-22 à 15.10.241432×1536 244 KB

Capture d’écran 2022-09-22 à 14.59.42
Capture d’écran 2022-09-22 à 14.59.421920×1361 81.1 KB

5

You don’t need the leading and trailing / characters.

Also you need at least one capture group. () will do it around your whole pattern.

6

Hi Alex,

Thanks for you help.

I’m not sure I understood what you said (sorry I’m a non-tech guy :stuck_out_tongue: )

How should I write it in the text parser module ?

I tried this :

(/+?\d{1,4}?[-.\s]?(?\d{1,3}?)?[-.\s]?\d{1,4}[-.\s]?\d{1,4}[-.\s]?\d{1,9}/g)

But it doesn’t work.

Best,

7

Try

(\+?\d{1,4}?[-.\s]?\(?\d{1,3}?\)?[-.\s]?\d{1,4}[-.\s]?\d{1,4}[-.\s]?\d{1,9})

Also work it in regex101.com first

1 Like
8

And if you need more help I’ll do the Regex work for you but with our make hero

We offer a one hour video call where we explain and show how Make can help your organization. We even build some scenarios and share them with you so get more value than a usual exploratory discussion. Book some time with me at Make.com Hero - NewPath Consulting I look forward to talking to you and your team should they join us.

1 Like
9

I’ve tested the pattern above and updated it:

(\+?\d{1,4}?[-.\s]?\(?\d{1,3}?\)?[-.\s]?\d{1,4}[-.\s]?\d{1,4}[-.\s]?\d{1,9})

The + and () needs to be escaped.