Lookup with 'contains'/REGEX

[Admin]

Glad it helps. Please also check out the use of word boundaries here:

Extracting the US state from messy address data

We were asked recently about how to extract the state part of dirty address data, like this: 632 Del Monte Ave. Powhatan, VIRGINIA 23139 733 Wood St. Passaic, NJ 07055 763 Mammoth Court Dunedin, fl 25 Randall Mill Street Santa Cruz CA 755 magnolia avenue norristown, pa 19401 9 S. Vine Ave. Pembroke Pines, Florida 33028 18 Snake Hill Street Tallahassee, FL 32303 179 Prince Ave., Billings, Montana 59101 8570 Arcadia Street, Sewell, NJ 08080 9335 Fordham Ave. Lebanon, PA 17042 78 Br…

If you haven’t already.