How to remove the + sign if the phone number is looks like this?
Hey Alyssa,
isn’t that number supposed to be +1 5633213600? Why is it coming in backwards? Can you share what module is returning this?
You can use get(split(phone;+);1) to get the number only, but it will be infinitely better if you can get the correct format to begin with.
1 Like
Hi Stoyan,
The phone number information was captured from the Google Ads Lead Form Response. However, this issue has now been fixed by using a formula.
Appreciate you notice my post here :
1 Like
If you have a phone number coming from somewhere, you can use the Parse a Phone Number module to check if its valid and to get it in several different usable formats. This one will also handle variability in the input so you wont need formulas to check for things.
Yes after the Tools module, I used the Parse a Phone Number module to format again after the + and space remove.