Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Validation rule: Candian_Postal_Codes_in_Address

By praveen.sampath

Validation rule Details

Name

Candian_Postal_Codes_in_Address

Label

Candian_Postal_Codes_in_Address

Object

AQB__AQAddress__c

Active

No

Formula

AND(
OR( AQB__Country__c = "CA", AQB__Country__c = "Canada", AQB__Country__c ="CN"),
NOT(REGEX(AQB__PostalCode__c, "((?i)[ABCEGHJKLMNPRSTVXY]\\d[A-Z]?\\s?\\d[A-Z]\\d)?"))
)

Error message

Canadian postal code must be in A9A 9A9 format.

Error location

Postal Code

Related content