AnsweredAssumed Answered

Parse out a word from a field in field calculator

Question asked by scheadley on Sep 11, 2014
Latest reply on Sep 11, 2014 by ad_giles@hotmail.com

I have a field called Address.  And example of a record in that field is 900 Main St.  I need to get "Main" into a field called Street Name.  I already parsed out the street number(900) and the street type (St), but can't figure out how to do the name.  I'm working in ArcMap, so I would like to do it right in the table field calculator.  I have over 7,000 records I need to do this to.

 

Thanks

Outcomes