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...
Zaya__OSSE-Cont's avatar
Zaya__OSSE-Cont
Qrew Trainee
7 years ago
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. 
GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
7 years ago
if it starts with a 0, why not create a formula to remove the initial 0?