I have a string such as

```
397 Walker Road                                   Wayne, PA  19087

```

I need to extract the address information (street address, city, state, zip) from it. The problem is, the amount of white space is not consistent in the database. 

I've split the string on the comma, and extracted the state and zip. But am at a loss on how to get the city out of there, especially since the white space is inconsistent.