Hi all! On an api request I get the number of whatsapp +5511988998899 but to find a person on my CRM I need to find with +55 11988998899. How can I parse this number and convert with this space?

Hi, this is pretty simple to do assuming it will always be a 14 character string and the position will always be the same. You will need to select the “Text and binary tabs” in whatever module you want to modify and select the “Substring” function. Insert your original number in the first slot and…

[image] AnthonyatXRAY: assuming it will always be a 14 character string and the position will always be the same What if the country code is a single digit or three digits long? Don’t you think there should be a better way to parse an international phone number into its country code and loca…

Convert a international phone number format

Questions

Stoyan_Vatov February 26, 2024, 2:52pm 4

Hello,

there is a Parse a phone number module you can use to get the number in several different formats.

3 Likes

Topic		Replies	Views
Phone number format Extract 10 digit number without area code and dash Questions google-sheets	7	196	December 10, 2025
How to format phone numbers Questions functions	5	2285	April 4, 2024
Convert International Phone number Questions functions , mapping	7	388	August 15, 2024
Parsing a phone number into different formats from a webhook Questions text-parser	6	64	February 9, 2026
Changing form of phone number I get from one app when i put it in google sheets Beginner Questions google-sheets	5	54	February 24, 2026

Convert a international phone number format

Related topics