USZIP (standardization function)

This function formats U.S. postal codes.

Output Type
numeric
Fldargs
zipcode
MinFldArgs, MaxFldArgs
1,1
Number of standard roles
1
MinLength, MaxLength
5,5
  1. This function first does the CMAP standardization. The non-digits are then stripped from the string.
  2. If the length is less than 5, the value is treated as anonymous. If it is greater than 5 it is truncated to 5.
  3. The mpi_dvdxstd table is then checked to see if there is an ANON table specified. If specified, the attribute is checked with the table and if the value is found, the attribute is treated as ANON.
  4. The mpi_dvdxstd table is then checked to see if there is any EQUI table specified. If specified, the attribute value is checked and if not found, the value is treated as ANON.
  5. The attribute value is then added to the comparison string.
USZIP example:

78749-2000 gets converted to 78749
78749A gets converted to 78749
787-49 gets converted to 78749
7874 is treated as ANON