Integrity: USAREA Rule Set

This forum is in support of all issues about Data Quality regarding DataStage and other strategies.

Moderators: chulett, rschirm

Post Reply
timwalsh
Participant
Posts: 29
Joined: Tue Mar 04, 2003 7:48 am

Integrity: USAREA Rule Set

Post by timwalsh »

I am passing US City, State, Country and Zip code data to Integrity.
Within Integrity I am using the SuperStan procedure to Standardize the Area data to conform to Integrities standard output.

Integrity handles City, State and Country very well. Unfortunately, it is sending all the Zip code data to the UnhandledData field and not to the ZipCode5 and ZipCode4 fields.

Inputs look like:
Springfield 17305-1801 PA U.S.A
Atlanta 30332-1512 GA USA

Outputs in the UnhandledData field look like:
17305 1801
30332 1501

Pattern for all data (S^-^S+.A.+.)

I figured that it would be take into account in this section of the USAREA code:
Subroutine US_Zip_Codes, Section 1

Any suggestions would be greatly appreciated.

Tim
timwalsh
Participant
Posts: 29
Joined: Tue Mar 04, 2003 7:48 am

Integrity: USAREA Rule Set

Post by timwalsh »

The input data must be in the exact order:
City, State, Zip Code, Country.

Then it works fine.
Post Reply