IsNumeric ( text )
Is the string numeric? (is it a number?)
Be the first to rate this function Log in to vote
Kyle Williams - Show more from this author
IsNumeric ( "125.00")
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Sometimes you need to verify that a serial number is numerical before merging 2 tables to avoid errors, Sometimes you just need to verify that a dollar value was entered as a number and not as "$102.00" or "102,00" or "102.00."
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.