Skip to main content

I am looking to filter properties for owners that live out of state. I get information from my data source in the format below. What’s a Regex formula I can use to separate out the City, State, and 5digit ZIP?


I take it that you’re looking for three fields, therefore three formulas. Here’s what I came up with for a {City} field formula:


IF({Recorded Owner City State Zip}, REGEX_EXTRACT({Recorded Owner City State Zip}, "(.*)(?:,.*)"))

{State} field formula:


IF({Recorded Owner City State Zip}, REGEX_EXTRACT({Recorded Owner City State Zip}, "(?:, )(.{2})"))

{Zip} field formula:


IF({Recorded Owner City State Zip}, REGEX_EXTRACT({Recorded Owner City State Zip}, "\\d{5}"))

Reply


Terms & Conditions