About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Formatter Tool: Issue With Formatting Phone Number... What Am I Doing Wrong?

  • 9 April 2020
  • 9 replies
  • 1699 views
blasemedia
Userlevel 2

Hi there.  I am attempting to format a phone number in order to remove the parenthesis, dashes and spaces.  I have done this a number of times in other zaps and have not run into any issues.

For some reason, on the zap sequence I am building today - the phone number formatter is not working properly.

I recorded a 1 minute video showing what it’s doing, please take a look and let me know what you think.  Am I crazy?  This has worked for me in the past…

 

https://www.loom.com/share/1c1a131a89c24d688d870e0fa28835d8

 

icon

Best answer by Danvers 27 April 2020, 18:07

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

ikbelkirasan
Userlevel 7
Badge +12

Hi @blasemedia - I can confirm, it shouldn’t include any symbols but for some reason, it does!

@Danvers, can you help with that?

 

 

Ikbel | Building custom Zapier Apps | Want to build a custom Zapier app for an API? Visit our website: https://norapps.com Or email us at info@norapps.net
W
Userlevel 1

I am trying to do something similar but opposite. Transform: 5555555555 -→ (555) 555-5555 

On output it is still giving me 5555555555

Is there a bug in zapier formatter right now?

ikbelkirasan
Userlevel 7
Badge +12

The output is currently returning the exact same input, so it seems to be a bug in the Formatter.

Ikbel | Building custom Zapier Apps | Want to build a custom Zapier app for an API? Visit our website: https://norapps.com Or email us at info@norapps.net
AndrewJDavison_Luhhu
Userlevel 7
Badge +10

I’ve also had this bug happen - will flag to the team.

Sit tight everyone.

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
Liz_Roberts
Userlevel 7
Badge +8

Thanks @AndrewJDavison_Luhhu !

@Wyatt & @blasemedia I have escalated this to Support and will circle back to update this thread just as soon as they have taken a look!

blasemedia
Userlevel 2

Does anyone have any ideas for how I might be able to to reformat the phone number using the code step?

I need to do the following:

  • Remove parenthesis
  • Remove spaces
  • Remove hyphens
  • Prepend a 1

Any creative ideas for how I might be able to accomplish this with a different method?

 

Thanks!

ikbelkirasan
Userlevel 7
Badge +12

@blasemedia - Try this code. It should return 17774445555 for this input (777) 444-5555

const phone = `1${inputData.phone.replace(/[\(\)\- ]/g, "")}`;

output = [{ phone }];
Ikbel | Building custom Zapier Apps | Want to build a custom Zapier app for an API? Visit our website: https://norapps.com Or email us at info@norapps.net
blasemedia
Userlevel 2

Thanks @ikbelkirasan 

I am hoping they can update the expected functionality for formatting the phone number as I have dozens of these “in the wild” I would need to hunt down and update.

cc @Liz_Roberts 

Danvers
Userlevel 7
Badge +12

I can see that the Support Team came back to you on this and confirmed that it’s an issue with the Formatter. The reason that it’s running into this issue is because the Formatter is looking for a valid phone number (based in the country selected) and if there’s something that doesn’t fit, then it wont format it.

 

We are looking for a way to improve this, and in the mean time, if what you need is to remove all symbols from the phone number, then it looks like @ikbelkirasan has you covered with that brilliant code step!

 

Try this code. It should return 17774445555 for this input (777) 444-5555

const phone = `1${inputData.phone.replace(/[\(\)\- ]/g, "")}`;

output = [{ phone }];
Terms & Conditions