I have a variable that holds a city and state... for example: HOUSTON TX. I only want the State in the variable. So I use the split function like this split(var," ")(1). The only problem is that sometimes the variable has a two part city like Middleburg Heights OH. How can I get the State only?