is_valid_number ( some_text )
returns true (1) if the input text represents a valid number
Average rating: 4.6 (32 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
useful for determining whether a string represents a valid number, including handing of negative numbers and decimal values; ignores leading and trailing spaces, but enforces proper use of hyphen (minus) and period (decimal point) if present
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.