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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Format number

  • 28 March 2020
  • 2 replies
  • 94 views
S

Hello,

 

I have a a input like : 143 000 €

I would like : 143000

But the formating utility take me 143.000 or 143,000

How to have only 143000

 

Thanks you in advance for your help

 

icon

Best answer by jesse 10 June 2020, 19:26

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.

2 replies

nicksimard
Userlevel 7
Badge +11

Hi Seb,

I can see that you’ve received a response from our support team about this question. Can you confirm whether their suggested solution gets you what you need? If so, I can add that here so that others are able to find it if they run into a similar situation :)

Thanks!

jesse
Userlevel 7
Badge +9

Hey @Seb, we just wanted to follow-up on this thread. It looks like our support team recommended using the Formatter by Zapier > Text > Replace option.

This way, you can use the "143 000 €" number as the "Input," you can use "€" as the "Find" field, and put nothing in the "Replace" field. This will cause "143 000 €" to turn into "143 000". From there, you could do the same thing with spaces if you then wanted to get that number to “143000”.

Terms & Conditions