AnsweredAssumed Answered

Trim strings at specific point using Field Calculator

Question asked by dgfrese on Dec 9, 2014
Latest reply on Jan 13, 2015 by tkowal

I have a feature class which contains 40,000 mailing addresses. Each address contains the street address, city, state and zipcode separated by spaces.

 

Example 1: 123 Northwest Johnson St Cleveland Ohio 12345

Example 2: PO Box 3 Pine Springs Ohio 12345

 

I want to pull out just the street addresses. How do I say: trim off the string starting at the 3rd or 4th to last space? Thanks. Any help would be appreciated. I'm trying combinations of split, trim, etc. but can't get it right.

Outcomes