Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Regex for this field?

Topic Labels: Formulas
Solved
221 1
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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?

1 Solution

Accepted Solutions
18 - Pluto

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

18 - Pluto

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