Glen, your solution is perfect if we did not have cities with more than one name...
CITY: ELM
STATE: CITY
ZIP: NC
CITY: WILSON
STATE: NC
ZIP: 27893-9226
I have 5 name lines, each pic x(36). There are no edits on these fields, so there is not a consistent delimiter. I have to feed city state and zip separately into a piece of software that standardizes addresses. I can start on name 5 and work backwards looking for a name field not spaces. At...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.