You need to sign in to do that
Don't have an account?
Rehana Wajahat Hussain
Regex Formula Validation to require [a-z][A-Z][0-9] . , : ; ! / and \?
Hi!
I would love to get some help with this validation rule:
I want this Comments field to include Special characters: . , : ? ; % ( ) & # ' " * - _
My Validation formula works for all the special characters except \ backslash and hyphen represents the range in order to consider it as the literal value I need to escape it using two back slashes.
AND (
NOT(ISBLANK( Comments )),
NOT(REGEX( Comments , "[a-zA-Z0-9.,:?;%/()&#\'!\"\"\\-_* ]+")),
)
I would love to get some help with this validation rule:
I want this Comments field to include Special characters: . , : ? ; % ( ) & # ' " * - _
My Validation formula works for all the special characters except \ backslash and hyphen represents the range in order to consider it as the literal value I need to escape it using two back slashes.
AND (
NOT(ISBLANK( Comments )),
NOT(REGEX( Comments , "[a-zA-Z0-9.,:?;%/()&#\'!\"\"\\-_* ]+")),
)
Hi Rehana Wajahat Hussain,
Please refer to the below link exactly with similar issue.
Kindly modify the code as per your requirement which helps you surpass the above challenge.
Can't escape the backslash with regex? (http://stackoverflow.com/questions/4025482/cant-escape-the-backslash-with-regex)
If this helps,please mark it as best answer.