Skip to main content

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

 

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!


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”.