IsNumber ( text )

Test the input to see if it is a valid number.

Be the first to rate this function Log in to vote

Josh Ormond - Show more from this author
Iozax, LLC
http://iozax.com

Sample input:

IsNumer ( "-" )
IsNumer ( "1999.00" )
IsNumer ( "abc123" )
IsNumer ( .5 )

Sample output:

0
1
0
1

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

/**
*======================================
* IsNumeric
*
* RETURNS:
*		boolean
*
* PARAMETERS:
*		none
*
* DEPENDENCIES: 
* 		none
*
* HISTORY:
*		2022-02-17 Josh Ormond ( jormond@iozax.com ) - created
*
*======================================
*/

Let ( [
	body = If ( Left ( text ; 1 ) = "-" ; Middle ( text ; 2 ; Length ( text ) ) ; text )

] ;
	not IsEmpty ( Filter ( body ; "0123456789" ) )
	and Filter ( body ; "0123456789." ) = body
	and PatternCount ( body ; "." ) ≤ 1
)

Test the input to see if it is a valid number. Since `GetAsNumber ( )` and `ABS ( )` may transform the number to a slightly different format, they can't be solely relied upon for this test case.

Comments

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

IsNumber ( text )

Comments

Support this website.

Support this website.