I have a field text that cannot contain either l m or p whether it is upper or lower case. How can I accomplish this in a validation rule?
Please give examples. Perhaps a regular expression example or if there are functions that can be used
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
The regular expression would look like this:
/[lmp]/gixm. Here's a very handy utility for determining regular expressions which is courtesy of GSkinner. You didn't say whether the field was rich text or not, so I've included flags that assumed it was.
Here's a link to Useful Validation Rules which should provide you with plenty of examples to help you figure out how to implement the rest of what you need. I know it contains some Regex examples.