You need to sign in to do that
Don't have an account?
Dane Kim 18
Validation Rule to Detect Letters
Hey guys,
Simple validation rule with regex isn't working. The idea is to enforce an account name that is in the format of 0#ABCDEF (i.e. 01BAEFDC).
The first regex formula is working (first two characters are 0#). The last line isn't. Any thoughts?
Simple validation rule with regex isn't working. The idea is to enforce an account name that is in the format of 0#ABCDEF (i.e. 01BAEFDC).
LEN(Name) != 8 || !(REGEX(LEFT(Name ,2),'[0][0-9]')) || !(REGEX(RIGHT(Name ,6),'[A-Z]'))
The first regex formula is working (first two characters are 0#). The last line isn't. Any thoughts?