Brian Dunning's FileMaker Custom Functions

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   Dr. Ronald W. Satz
Transpower Corporation
http://www.transpowercorp.com

Share on Facebook Share on Twitter

  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)

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

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.