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
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).
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.