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

Steve Harley - Show more from this author

Sample input:

is_number ("-012.30")

Sample output:

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

Let ([
    t = Trim (some_text);
    is_numeric = Exact (Filter (t; ".-0123456789"); t);
    minus_count = PatternCount (t; "-");
    good_minus = (minus_count = 0) or ((minus_count = 1) and 
(Left (t; 1) = "-"));
    good_point = (PatternCount (t; ".") <= 1)
    ];
  is_numeric and good_minus and good_point
  )

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

Comments

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

is_valid_number ( some_text )

Comments

Support this website.

Support this website.