Work with numbers and points

I have a number and I need to remove the last point without removing the numbers, how can I do this? example in the photo

image

What is your expected output?

4.173.7 = 4.173 ?

If so, you could use a text parser to extract everything up to but not including the last decimal/period. The pattern could be something like this:

Result:

Here you can test multiple values to be sure it will capture the correct result: regex101: build, test, and debug regex

3 Likes