[SalesForce] REGEX in Validation Rule

I have a custom field on an object which should allow values based on the following JavaScript REGEX.

/[^\sa-zA-Z0-9.,:?;%/()'!""-]/g

Can anyone help me how to use this REGEX in validation rule ?

Best Answer

You should screen with \ such literals as \, ', " and use REGEX(text, regex_text) in validation rule's formula field.

So, for example, if you want your field match the regex, you should write the formula like this:

NOT(REGEX(CustomField__c, "[\\sa-zA-Z0-9.,:?;%/()\'!\"\"-]*"))

Explanation: add NOT(), therefore if the field matches regex it does not be caught as error condition.

Here is the link to documentation: https://help.salesforce.com/articleView?id=customize_functions_i_z.htm&type=5

Related Solutions

[SalesForce] Regex in the validation rule

Try this RegEx [0-9]{6}(;[0-9]{6})*

[SalesForce] Validation rule to allow 15 digits only

The logic is over-complicated; the second regex returns false when there are only numbers, but you actually wanted it to return true regardless. You can simplify this formula to:

OR( LEN(custom_text_field__c) <> 15, NOT(REGEX(custom_text_field__c,"^[0-9]+$")))

If you want to allow blank values, you need to add that in, too:

AND(NOT(ISBLANK(custom_text_field__c)),
OR( LEN(custom_text_field__c) <> 15, NOT(REGEX(custom_text_field__c,"^[0-9]+$"))))

Best Answer

Related Solutions

[SalesForce] Regex in the validation rule

[SalesForce] Validation rule to allow 15 digits only

Related Topic