Format phone ex. +525535369825 to 5215535369825

How To
1

Hi! I am using a scenario where I need to find phone records in order to answer a customer with whatsapp and I have filters (found or not found) but none of my records are found because the phone number from WA came with this format 5215535369825 and in my records I have this format +525535369825.
Can someone help me?

Thanks

2

You can use the built-in function replace

e.g.:

{{ replace(1.text; "+52"; "521") }}

For more information, see the function documentation in the Help Center.

3

Hi! Thanks! but if I map the phone in this function it’s now working, am I missing something?
image
image

4

I map “521” but I don’t know why it dissapeared

5

You don’t need the double quotes if you’re not copying and pasting the full line including the {{}}

1 Like
6

Hi Valeria.

This is a common issue with Mexican numbers and WhatsApp after the change in the Mexican numbering plan that took effect in 2016.

A somewhat easy fix is to have a separate field in your contacts directory that you will use for searching. This field should contain only the last 10 digits of the number. For example: 5535369825.

The next time you search, you extract the last 10 digits of the incoming number and do the lookup using the auxiliary field you created. When the record is found, the row will also have the field with the full number that you can use to send the reply or match the contact.

In case it helps, at 2Chat we do this conversion automatically and we integrate natively with Make.

[1] https://www.make.com/en/integrations/two-chat