We’d like to “purge” all the phone numbers we receive via a webhook. The aim would be to transform all the numbers so that they are identical, for example: “0600000000”.
When we receive them, some may be written with periods, commas, spaces, ect ect. Also, some start with “+33” or even “+3333” for those coming from meta… I’ve figured out how to clean up all the numbers using a google sheet formula, but my last problem is that numbers starting with “+33” and having spaces afterwards are considered as formulas and can’t be used in other formulas because "error!
I’ve tried to use the Text parser replace module to remove the “+” pattern, but I can’t. Can you help me?
There is a very handy tool for phone number parsing freely available in Make already, it is this one:
It will parse most phone numbers that you put in into a national/international or normalized format. Of course, if you put in a number that does not resemble a phone number, it cannot parse it correctly.
Hello Henk,
Thank you for your solution, it works well, we’re almost a little disgusted that the solution is so simple and under our nose from the beginning ^^.
At least now it’s good, thanks again.
Have a nice day,
Meven
