My scenario is
I have 5 country code (BillingCountryCode) with 5 diff zipcode (BillingPostalCode) with diff patterns.
Ex
AT - 3344 (only 4 numbers)
BG - 33445 (only 5 numbers)
CA - 33445AB (4 numbers and 2 letters)
BillingCountryCode and BillingPostalCode(String type) are standard fields on Account, Now I have a new formula checkbox field on account as well.
This checkbox field I want to check as FALSE for all those records whenever a BillingPostalCode doesn’t match with the pattern for the respective BillingCountryCode
Using batch I can do that by storing this using custom meta data .and then querying it out and update the field accordingly.
I want to understand if it’s doable using formula field as I need to use regex here.
Can somebody pls help me here
The REGEX Function is not available in Formula Fields
