Regex for this field?

[AM858]

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?

[Justin_Barrett · Accepted solution]

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}"))