Forum Discussion

MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
8 years ago

Is there a way to test in a formula if a text field contains a valid number?

I have a complex text formula field that extracts out text from another text field. If it contains a number, I want to use it in another formula field's calculations. If not, I want to skip over it an...
MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
8 years ago
Thanks Mark. That's clever, but I couldn't get it to work. For my current purposes, this seems to have done the trick. 

Length([Subject Form ID]) > 0 and Left([Subject Form ID],1) >= "1" and Left([Subject Form ID],1) <= "9"

It really bugs me, though, that there isn't a native function to do something so straightforward and necessary.