Forum Discussion

Qrew Member

3 years ago

If statement to check for numeric

How do you check if a text data field only contains a number or is just numeric. I have an address field that I need to perform an If statement such as: If property address is numeric then set "Y"...

Formulas and functions

MarkShnier__You

Qrew Legend

3 years ago

not tested but try this
var text TextConvertedToNumericAndBack = ToText(ToNumber(Trim([My Text field field])));

IF($TextConvertedToNumericAndBack = Trim([My Text field field])
and
Length($TextConvertedToNumericAndBack) = Trim([My Text field field]), "Y", "N")

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------