Extract phone number from google calendar description

[Carlos_Herrera]

Hi, I’m using this template https://www.make.com/en/templates/5937-create-google-calendar-events-from-data-on-your-google-sheet

I’ve this google calendar description event

How can I extract the phone number (584122677132) and add on another column at spreadsheet

Thanks

[Msquare_Automation]

Hi @Carlos_Herrera

If the data comes as text you can use Regex to collect particular data.
To learn regex, please check below link

regex101: build, test, and debug regex

eg:

Collect Week.
In the example I am used (?<=Week)([\s\S]*?)(?=\n) regex.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

[samliew]

Hi @Carlos_Herrera,

You can match a 12-digit phone number using the following regular expression pattern:

(?<phone>\d{12})

This will allow you to map the variable in a subsequent module:

[Carlos_Herrera]

Thanks a lot for this

Works perfect

[Carlos_Herrera]

@samliew

(?<phone>\d{12})

Hi, i’m here again jeje

It’s nor working now output not working

This is the module config

Thanks again

[samliew]

Looks like your phone number is 11 digits in this case.

You can update the regex to this to capture numbers between 11 and 12 digits inclusive:

(?<phone>\d{11,12})

[Carlos_Herrera]

@samliew

(?<phone>\d{11,12})

Thanks again working again

[samliew]

No problem, glad I could help!