Checking if characters in a text string are all numeric

Question

Looking for ideas for how I might check each individual character in a text string to ensure its a number. If all characters are numbers the result should be 'true'. If even 1 character is not numeric then the result should be 'false'

------------------------------
Scott Pugh
------------------------------

MarkShnierYou · Answer

This seems to work for me to validate the field called [data entry]. A blank entry will also qualify as being OK using this formula.

var text DataEntryConvertedToNumberAndbackToText = ToText(ToNumber([data entry]));

$DataEntryConvertedToNumberAndbackToText = [data entry]
and
Length($DataEntryConvertedToNumberAndbackToText)= Length([data entry])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community