/
Validation rule: Canadian_Postal_Code_in_Mailing_Address

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: Canadian_Postal_Code_in_Mailing_Address

Owned by praveen.sampath
Aug 16, 2024
1 min read

Validation rule Details

Name

Canadian_Postal_Code_in_Mailing_Address

Label

Canadian_Postal_Code_in_Mailing_Address

Object

Contact

Active

No

Formula

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

Error message

Canadian postal code must be in A9A 9A9 format.

Error location

Contact.OtherPostalCode

Related content

Validation rule: Canadian_Postal_Codes_in_Shiping_Address
Validation rule: Canadian_Postal_Codes_in_Shiping_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Candian_Postal_Codes_in_Address
Validation rule: Candian_Postal_Codes_in_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Canadian_Postal_Codes_in_Billing_Address
Validation rule: Canadian_Postal_Codes_in_Billing_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Canadian_Postal_Codes_in_Perm_Addres
Validation rule: Canadian_Postal_Codes_in_Perm_Addres
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Mail_Address_Abbrev
Validation rule: Valid_Canada_Prov_in_Mail_Address_Abbrev
TAP - Advancement Portfolio Product
More like this
Validation rule: US_Postal_Code_in_Mailing_Address
Validation rule: US_Postal_Code_in_Mailing_Address
TAP - Advancement Portfolio Product
More like this