I am working on a data conversion project and I am trying to find the zip in the field(s). It can be in adr3 or adr2 field and I have to figure out how to parse it out to a zip field. The problem is the data is not consistent. Here are some examples of what the data looks like. The input file is pic x(48) for adr1, adr2, adr3. We are moving to a file where the maximum field length is 28. If zip is not in adr3 than I need to look for it in adr2.
Suite 160 Phoenix AZ 85018 Phoenix AZ 85019 Phoenix AZ 85019 Phoenix AZ 85019-11111 Phoenix AZ 85019 11111
Any help would be appreciated!
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.