# trimming numbers with multiple decimals in them

This topic is 2600 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I have a field called version. Some of the values contain multiple decimals for example

10.12.73.10

I want to trim them down to only contain 1 decimal so in other words 10.12.73.10 would become 10.12

another example would be 7456.342.4728.123 would become 7456.342

how do i do that?

Thanks again!

-Erik

##### Share on other sites

Try:

```Let (
dot2 = Position ( Version ; "." ; 1 ; 2 )
;
Case ( dot2 ; Left ( Version ; dot2 - 1 ) ; Version )
)```

--

What the heck, let's have another:

` Substitute ( LeftWords ( Substitute ( Version ; "." ; ¶ ) ; 2 ) ; ¶ ; "." )`
Edited by comment
• 2
##### Share on other sites

This, not simpler, is another one:

```Left ( version ; Max ( Position ( version & "." ; "." ; 1 ; 1 ) - 1 ; Position ( version & "." ; "." ; 1 ; 2 ) - 1 ) )
```
Edited by Raybaudi
##### Share on other sites

This, not simpler, is another one:

```Left ( version ; Max ( Position ( version & "." ; "." ; 1 ; 1 ) - 1 ; Position ( version ; "." ; 1 ; 2 ) - 1 ) )
```

You didn't test this with "123.45".

##### Share on other sites

I did, but I'm missing something. Calculation edited.

##### Share on other sites

Thanks guys but I'm getting my numbers in a weird format. I didi exactly what you listed above in the first Position formula. It is making the first decimal a comma.

##### Share on other sites

It is making the first decimal a comma.

That could happen if (1) the calculation result type is set to Number (it should be Text, of course) and (2) your file is set to use comma as the decimal separator.

##### Share on other sites

This topic is 2600 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account