How to Remove the Last Point from a Number on Make.com

Have you ever found yourself in a situation where you have a number and you need to remove the last point without removing the numbers? This is a common problem that many people face, especially when dealing with data that has been formatted in a certain way. In this blog post, we will walk you through a step-by-step solution to this problem.

The Problem

Let's say you have a number like 4.173.7 and you want to remove the last point to get 4.173. How can you do this?

The Solution

The solution to this problem is to use a text parser to extract everything up to but not including the last decimal/period. The pattern could be something like this:

Result:

You can test multiple values to be sure it will capture the correct result. A great tool for this is regex101, which allows you to build, test, and debug regex. You can find it here: https://regex101.com/r/4sRRuw/3

Troubleshooting Tips

If you're having trouble with this solution, make sure you're entering the correct pattern into the text parser. Also, make sure you're testing with multiple values to ensure the solution works for all possible scenarios.

Conclusion

In conclusion, removing the last point from a number doesn't have to be a difficult task. With the right tools and a little bit of knowledge, you can easily solve this problem. We hope this blog post has been helpful and has provided you with a solution to this common problem.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.