Forum Discussion

MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
7 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...
Zaya__OSSE-Cont's avatar
Zaya__OSSE-Cont
Qrew Trainee
Sorry to resurrect an old post but this is the closest post I've found that's similar to the problem I'm struggling with. 
I have a text field that's supposed to have all numbers except for dashes. I need to do IsNumeric type of validation. While Mark's formula is working great, my field can start with 0 so I can't use it. And changing the field to numeric is not an option at this point due to other dependencies. I've tried many different approaches with no luck. Any help would be greatly appreciated. 
Zaya__OSSE-Cont's avatar
Zaya__OSSE-Cont
Qrew Trainee
6 years ago
It's SSN field that allows either null, all 9 digits or just last 4 digits. So the format is either empty, 123-456-789 or 0123.