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
I'm working on a validation that would require a user to enter only numbers that have to be exactly 9 numbers and be separated by lines. The below is working for that, but is it possible with straight RegEx to add criteria prevent a duplicate of any number set?
!REGEX(SomeCustomField__c, '^[0-9]{9}+(\r\n[0-9]{9}+)*$')
If there way you can prevent a number from appearing twice without Apex?
123456789
123456780
// Prevent duplicate of any number already entered
123456789
123456780
Yes, regex can do this.
NOT(REGEX(SomeCustomField__c, '^(?s)\\d{9}(\\s+\\d{9})$')) ||
REGEX(SomeCustomField__c, '(?s)(\\d{9}).*\\1')
The trick here is that we go in to "single line mode" (?s) to allow . to match newlines, then we check each nine-digit string (\\d{9}) with any intervening characters (.*), followed by the same group again (\\1).