Address Cleanup

The Address Cleanup tool will set standardized abbreviations in address fields and fill in missing counties.

IMPORTANT

We strongly recommend making a backup before running this tool.

To run the tool:

1. Select Tools > Data Cleanup > Address Cleanup.

2. Enter the criteria to select Name records (e.g. add date, update date, creator).
3. Select the cleanup routine(s) to run:

• Assign Missing Counties.
• Standardize Address - will set standardized abbreviations for the following:

Apartment to Apt
Avenue to Ave
Basement to Bsmt
Boulevard to Blvd
Building to Bldg
Center to Ctr
Circle to Cir
Court to Ct
Department to Dept
Drive to Dr
Expressway to Expy
Floor to Fl
Landing to Lndg
Lane to Ln
Highway to Hwy
P.O. to PO
Parkway to Pkwy
Place to Pl
Plaza to Plz
Road to Rd
Room to Rm
Square to Sq
Street to St
Suite to Ste

4. Click the Run button.