String2ScientificNotation ( string ; precision )

Returns the scientific notation of an alphanum string associated with a measuring unit.

Average rating: 4.4 (30 votes) Log in to vote

Clement Hoffmann - Show more from this author
none
none

Sample input:

String2ScientificNotation ( 642309000 mm ; 6 )

String2ScientificNotation ( 0,0068824103655438983 µm; 10 )

Sample output:

6,42309e3

6,8824103655e-9

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*-- String2ScienticNotation ( string ; precision )
Author: Clement Hoffmann
email: clemhoff@yahoo.fr
------------------------------------- */


Let (
    [
        _ds= Left ( 1/2 ; 1 ) ;

        %units = "m¶mm¶µm¶nm¶pm¶fm¶am¶" ;
        _unitTxt = Lower ( RightWords ( string ; 1 ) ) ;
        _pwr = -3 * ( ValueCount ( Left ( %units ; Position ( %units ; RightWords ( string ; 1 ) & ¶ ; 1 ; 1 ) ) ) - 1 ) ;

        var1 = GetAsNumber ( string * ( 10 ^ _pwr ) ) * 10 ^ 200 ;
        var2 = Abs ( var1 ) ;
        var3 = 10 ^ Int ( Log ( var2 ) / Log ( 10 ) ) ;
        var4 = Round ( var2 / var3 ; precision )
    ] ;
    If (
        Position ( %units ; _unitTxt & ¶ ; 1 ; 1 ) ;
        Case ( var1 < 0 ; "-" ; "" ) & Case ( var4 = 10 or var4 = 1 ; "1" & _ds & "0" ; var4 ) & "e" &
        ( Int ( Log ( var2 ) / Log ( 10 ) ) - 200 ) - Case ( var4 = 10 ; 1 ; 0 )
    )
)

Returns the scientific notation of an alphanum string associated with a measuring unit.

The value returned can be used for other calculations.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

String2ScientificNotation ( string ; precision )

Comments

Support this website.

Support this website.