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
If the data comes as text you can use Regex to collect particular data.
To learn regex, please check below link
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.
Visit us here
You can match a 12-digit phone number using the following regular expression pattern:
This will allow you to map the variable in a subsequent module:
Hi, i’m here again jeje
It’s nor working now output not working
This is the module config
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:
Thanks again working again
No problem, glad I could help!