0

I am creating a Validation Rule on the Account Name and Opportunity Name. Based on Israel, the rule should accept only English letters and special characters(&,_,! etc). IT SHOULD NOT let any user enter Hebraic letters.

I used this formule : AND(OR(ISBLANK( Name ), NOT(REGEX( Name ,"^[a-z A-Z]*$")))) BUT it does not let me enter any special characters.

Does someone have a solution in order to solve this request?

Improve this question
3
  • 1
    Take a look at the documentation for the underlying Java regex Pattern class to see more on character classes. Fundamentally you simply need to list the characters or character ranges you want to allow either directly or using "character classes" and negate it like you already do.
    – Phil W
    Jul 20, 2022 at 19:51
  • 3
    ...in addition to reading the docs, your goal is unclear - Cyrillic vs Hebraic vs...
    – identigral
    Jul 20, 2022 at 19:54
  • I create a validation rule checking that Account Name and Opportunity Name are not in entered in Hebraic letters.
    – Leslie
    Jul 21, 2022 at 7:01

1 Answer 1

Reset to default
-2

since you want to allow the special character to be accepted then try like below

AND(OR(ISBLANK( Name ), REGEX( Name ,"^[a-z A-Z]*$"))
Improve this answer
1
  • 1
    Huh? This is what the OP posted as not allowing symbols ("special characters")...
    – Phil W
    Jul 20, 2022 at 19:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .