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
Best answer
Format number
Best answer by jesse
Hey
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”.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Zapier Staff
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!
+9- Architect
- Answer
Hey
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”.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.