You need to sign in to do that
Don't have an account?
Pannar
Validation Rule - to check western characters?
Hi,
Is there way to create the validation rule on the particula custom field Name(Text(255) under Opportunity object.
There should be a restriction in that particular field that it should only allow western characters. Is it possible?
please respond.
regards
pannar
Validation rules can use the REGEX function, and this page has an example of using regular expressions to check to see if only western characters are in a string. Haven't tested it, but think it should work.
Of course, validations are applied on a record at save time, not on a field, but the validation can check the values in a field.
Hope this helps.
but it doesn't work. Its allowing me to enter any characters and saved the account record! :-(
Do i have to pass anything else for non-western chars checking?
Could you please tell me the range of Western characters which can be passed in REGEX. If i get the range, then i am done with my requirement.
thanks a lot
I work on the same exercise to force the Account Name to be in English/Western characters only. After researching from various sites and this, I finally derived a workable regex pattern for this purpose. Hope this will help the dev out there and to get some feedbacks on this, if any.
NOT(REGEX(Name, "^[a-zA-ZÀ-ÿ0-9-/ \\p{Punct}]*$"))
Cheers,
Brian