HI: I have an address like this. What is best way to extract street address and city?
The city isn't always MOULTRIE but the format is always like this. From the back of the string, the city is always the 3rd.
1221 my address dr 4 MOULTRIE GA 31768-3006
800 NORTHSIDE DR 3 MOULTRIE GA 31768