Validation rule for a float value

Hi,

I have a 2 text fields which accepts numbers. I need to validate to make sure it does not anything other than the following:

1. 0-9

2. +,-

3 .(period)

Basically validate for a float value. I checked in the help topics. could not find any function. How or which function should I ue

Thanks in Advance

Best Answer chosen by Admin (Salesforce Developers)

CaptainObvious
Try this:

NOT(REGEX(Custom_Field__c ,"^[-+]?\\d+(\\.\\d+)?$"))

CaptainObvious
Try this:

NOT(REGEX(Custom_Field__c ,"^[-+]?\\d+(\\.\\d+)?$"))

This was selected as the best answer

gv
Thanks Captain. That worked

Need an account? Sign Up

Have an account? Sign In