Skip to main content
Solved

Regex for this field?

  • August 5, 2021
  • 1 reply
  • 21 views
A
Forum|alt.badge.img+2
  • AM858
  • Participating Frequently

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?

Best answer by Justin_Barrett

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

1 reply

Justin_Barrett
Forum|alt.badge.img+21

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

Terms & ConditionsAccessibility statement