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
Steven,
I had more of a thought about this and to make it more robust it would be better to use the following python snippet:
def convertName(address):
newname = ""
newaddress = address.split(" ")
for word in range(1,len(newaddress) -1):
newname = newname + newaddress[word] + " "
return newname[:-1]
to use in the field calculator follow the screenshot: