The special menu is where most of your data manipulation and interaction functions reside. Validate records, fill and replace data, format and parse fields, and more from this menu.
Validate Records - Selecting this option takes you to the Validate Records screen, where you can choose specific settings for validating your data. Validation is required for Automation Presorts, and also helps to standardize and format your data.
Validate this Record - Validate the currently highlighted record. This will use the Quick Validate settings from the Properties screen.
Interact - Placing a check mark next to this option will allow you to interact with the USPS Database when using Single Record Validation on an undeliverable record. You will be able to filter the USPS Database by State, City, and Street to determine the problem with the selected record. For more information, see Correcting Bad Addresses.
Lookup - Run a quick lookup by entering an input address. Get critical postal data (barcode, carrier route, county name, time zone, and more) using any input data that you like.
Fill - Takes you to the Fill screen, where you can quickly replace columns of data inside of AccuZIP6. Fill a single piece of data into every record, or by selection, as well as choosing whether to replace, append to, or insert before the current contents of the field.
Replace - Replace any selection of data in a field of your choice. Useful for mass replacements of characters, or removal of unwanted characters (replacing a comma with nothing, for example).
Format - Change the formatting options of a field. Specify the capitalization and whether to use the Format Dictionary when changing the contents of the field.
Parse - Parse the contents of preset fields (Name, City, or Phone) into their individual components (First into Sal, First, Middle, Last, and Title, for example) using AccuZIP6's powerful parsing engine.
Optimize Database - Takes you to the Optimize Database screen, where you can perform several functions on your database. Rebuild indexes, delete foreign records, order for optimum performance (when validating), and more.
Script - Create a custom script using the same functions found in all of the AccuZIP6 menus. Automate features such as importing, validating, finding duplicates, running commands, search queries, and much more.