nelobynature
New Member
- Joined
- Sep 20, 2013
- Messages
- 4
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
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