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.