Change the Format of Addresses
CAUTION: This process alters data. We recommend backing up your data before proceeding.
With the Change Addresses process, you can:
- Add abbreviations to certain addresses
- Remove abbreviations from certain addresses
- Add or remove periods in abbreviations
- Change the case of the addresses
- Insert a comma between cities and states
Note: The following items do not change when you run this process:
- State abbreviations in the City/State Names Keyword list and on all address fields. For example, AZ is not changed to Az.
- The Country Code, such as USA, in the City/State Names Keyword list.
- On the File menu in your PDS program, click .
- Select your format and case options and which addresses you want to change.
- When you're ready, click Change Addresses.
Watch & Learn
Learn to clean up address abbreviations and case using the Change Addresses system process. 4 min 1 sec
It may take a minute for the video to display. To enlarge the video, click the Fullscreen icon in the video player (beside the play button).
To watch more videos, visit the PDS Video Library.