Modify Selected Records

Function

Description

Entering Constant Text checkbox

Checks the modification to each record.

Entering constant text

Places a constant value in the selected field.

Clearing a field

Deletes all data from the selected field.

Filtering characters

Makes global changes to characters in the selected field.

Replacing words

Globally changes words based on a replacement table.

Entering an expression to calculate

Calculates values for the selected field.

Padding ZIP Code with zeros

Places zeros in the spaces of the ZIP Code field if this action will result in a valid USPS ZIP Code.

Changing the date format

Changes the date format for non-date datatypes.

Calculating Walk Sequence

Adds walk sequence data to lists already in walk sequence order.

Genderizing

Assigns genders to records with First Name or Full Name data and a Gender field.

Entering an incremented value

Populates a field with sequential numbers, beginning with a user-defined starting value.

Marking fields

Marks any of the following fields: ACS Checkdigit, BMC Number, Date Printed, ZIP+4/DP Combo.

Copying / joining fields

Copies data from one or more fields to another.