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

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 June 18, 201411 yr by comment

This, not simpler, is another one:

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

Edited June 19, 201411 yr by Raybaudi

 

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

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

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.

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.