-
Instructions to Ask a Question
For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.
We offer seven comprehensive applications designed to help you efficiently manage and grow your business:
- Pabbly Connect
- Pabbly Subscription Billing
- Pabbly Email Marketing
- Pabbly Form Builder
- Pabbly Email Verification
- Pabbly Hook
- Pabbly Chatflow
Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.
🚀 Exclusive Lifetime Offers 🚀
We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:
- 🔥 Pabbly Connect — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
Make a one-time investment and enjoy the advantages of robust business management tools for years to come.
-
Not able to add country code
- Thread starter saroosh7
- Start date
Hi,
So, in the above workflow i have connected our UAE fb ads accounts, in that workflow we have multiple filteration steps, one of them is phone number, you see, people don't usually put correct info in the forms they submit on Fb ads, for eg, i have attached the just 4 different type of number we recieve in a campaigns, as you can see, one had 0 at the start, next one don't have to country code (which is 971) 3rd one is correct, but 4th one is where we got+ sign.
We want to change the data to 3rd value, country code without + sign and the rest of the number
So, in the above workflow i have connected our UAE fb ads accounts, in that workflow we have multiple filteration steps, one of them is phone number, you see, people don't usually put correct info in the forms they submit on Fb ads, for eg, i have attached the just 4 different type of number we recieve in a campaigns, as you can see, one had 0 at the start, next one don't have to country code (which is 971) 3rd one is correct, but 4th one is where we got+ sign.
We want to change the data to 3rd value, country code without + sign and the rest of the number
| 050 548 9612 |
| 504652910 |
| 971508239128 |
| +971 52 509 8551 |
Hello @saroosh7,
You can add a Number Formatter action step to your workflow and use the Spreadsheet Formula called RIGHT to extract the last nine digits of the number, removing the country code.
Refer to the attached image for more details. While adding this step, replace 11 with 9 to ensure you get the correct number format.
Let us know if you need any further assistance!
You can add a Number Formatter action step to your workflow and use the Spreadsheet Formula called RIGHT to extract the last nine digits of the number, removing the country code.
Refer to the attached image for more details. While adding this step, replace 11 with 9 to ensure you get the correct number format.
Let us know if you need any further assistance!
Hello @saroosh7,
The formula will work for numbers that do not contain a country code, as it extracts the last nine digits of the number. However, if your number contains spaces, you can use the Replace Text action to remove them first. Once the spaces are removed, you can map the response from that step to the previously suggested step.
Refer to the attached image for more details. Let us know if you need any further assistance!
The formula will work for numbers that do not contain a country code, as it extracts the last nine digits of the number. However, if your number contains spaces, you can use the Replace Text action to remove them first. Once the spaces are removed, you can map the response from that step to the previously suggested step.
Refer to the attached image for more details. Let us know if you need any further assistance!
Similar threads
