Parse out a word from a field in field calculator

SteveHeadley

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

AntGiles

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: