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 that point, I know I have the city state zip portion of the address. Now the problem becomes how do you extract that? Here are some examples of how the data looks. Keep in mind, some citys have more than one name and in most cases, the state is abbreviated correctly.
city state zip city state zip city/state/zip city ,state,zip city, state zip city state zip
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.