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!
Suite 160 Phoenix AZ 85018
Phoenix AZ 85019
Phoenix AZ 85019
Phoenix AZ 85019-11111
Phoenix AZ 85019 11111
Any help would be appreciated!