Soubhik
12/19/2019 - 3:26 PM

Canadian Billing Postal Code

Validates that the account Billing Zip/Postal Code is in the correct format if Billing Country is Canada.

1
content_copyfile_download
AND(
    OR(BillingCountry = "CAN", BillingCountry = "CA", BillingCountry = "Canada"),
    NOT(REGEX(BillingPostalCode, "((?i)[ABCEGHJKLMNPRSTVXY]\\d[A-Z]?\\s?\\d[A-Z]\\d)?"))
)