trimming numbers with multiple decimals in them

[etsmarines]

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

[comment]

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, 2014 by comment

[Raybaudi]

This, not simpler, is another one:

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

Edited June 19, 2014 by Raybaudi

[comment]

 

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

[Raybaudi]

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

[etsmarines]

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.

[comment]

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.