Apex Code Development You need to sign in to do that
Don't have an account?
Srinivasa Amarendra Reddy Vaka Validation Rule Regex to allow specific characters in a text field
Hi All,
I have a text field and would like to add a validation rule so users can only enter a certain set of characters in it. But my validation rule is failing with Syntax error here. Can someone help?
REGEX(field ,
"([a-zA-Z0-9 .?!,;:_@&/\'"`~()<>$#%])*")
Basically, it should allow alphanumeric characters including spaces AND any of the special characters that are listed here "Period
Question Mark
Exclamation Point
Comma
Semi-colon
Colon
Underscore
At Sign
Ampersand
Forward Slash
Back Slash
Apostrophe
Quote
Grave Accent
Tilde
Left Parenthesis
Right Parenthesis
Less Than
Greater Than
Dollar Sign
Pound/Number
Percent".
Regards
Amar
I have a text field and would like to add a validation rule so users can only enter a certain set of characters in it. But my validation rule is failing with Syntax error here. Can someone help?
REGEX(field ,
"([a-zA-Z0-9 .?!,;:_@&/\'"`~()<>$#%])*")
Basically, it should allow alphanumeric characters including spaces AND any of the special characters that are listed here "Period
Question Mark
Exclamation Point
Comma
Semi-colon
Colon
Underscore
At Sign
Ampersand
Forward Slash
Back Slash
Apostrophe
Quote
Grave Accent
Tilde
Left Parenthesis
Right Parenthesis
Less Than
Greater Than
Dollar Sign
Pound/Number
Percent".
Regards
Amar
Hi Amar,
Please check with below RegEx
"([a-zA-Z0-9 .?!,;:_@&/\'"`~()<>$#%])*"
It should be working.
Thanks
Sucharita
Thank you for the response. I just compared your regex and mine, I am unable to see any differences. can you please tell me what was changed?
REGEX(field ,"([a-zA-Z0-9 .?!,;:_@&/\'"`~()<>$#%])*") ===> Mine
"([a-zA-Z0-9 .?!,;:_@&/\'"`~()<>$#%])*" ===> Yours
Regards
Amar
Hi,
Please check the following :
REGEX( Status__c ,'([a-zA-Z0-9 .?!,;:_@&/\'"`~()<>$#%])')
Hope this helps
Thanks,
Sucharita