String_to_Number_in_Scientific_Notation ( text )

Replaces GetAsNumber for Strings in Scientific Notation

Average rating: 5.0 (2 votes) Log in to vote

Dr. Ronald W. Satz - Show more from this author
Transpower Corporation
http://www.transpowercorp.com

Sample input:

String_to_Number_in_Scientific_Notation ( "1.1234e+29" ) )

Sample output:

1.123400e+29

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

Let
      (
        [
          length_text = Length ( text ) ;
          pos_of_E = Position ( text ; "E" ; 1 ; 1 ) ;
          number_part_1_text =  Left ( text ; pos_of_E -1 ) ;
          number_part_1 = GetAsNumber ( number_part_1_text ) ;
          number_part_2 = GetAsNumber ( Right ( text ; length_text - pos_of_E ) ) ;
          number = number_part_1 * ( 10 ^ number_part_2 ) 
        ] ;

        ScientificNotation ( number ; 6 )
       
       
      )

GetAsNumber fails when the string contains a number in scientific notation. String_to_Numbter_in_Scientific_Notation fixes this problem. Note that this function calls another custom function, ScientificNotation--which you must have installed. You can, of course, set the precision for this latter function (6 in the above example).

Comments

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

String_to_Number_in_Scientific_Notation ( text )

Comments

Support this website.

Support this website.