Separating City from Address When Only Comma Sits Between City and State

[nelobynature]

Looking to extract the City from an address (which can be more than one or two words (ex: Winter Garden or Miami). The format I have is as follows: Address [space] City [comma] State Abbv [Space] Zip examples below:

6615 Mahan Dr Tallahassee, FL 32308
3838 S Dale Mabry Hwy Tampa, FL 33611
999 E Commercial Blvd Oakland Park, FL 33334
7550 NW 104th Ave Doral, FL 33178
201 NE Palm Coast Pkwy NE Palm Coast, FL 32137

All the solutions I've found on the boards either have all commas or spaces as deliminator which doesn't work for this one.

Thanks in advance,
Nelson

 

[MoshiM]

The previous code works but changing the if statement to the following will reduce the likelihood of errors.

Nevermind. Original is better.

 

[nelobynature]

Thanks kweaver. This worked great!

 

[MoshiM]

Thanks kweaver. This worked great!

Can you try mine as well. It should work even if you use cities outside of Florida.