Address Refielder

Name and address information is typically gathered from many different sources, such as sales, telemarketing, and accounting. This often results in fielding inconsistencies that make it difficult to consolidate and process address data. The Address Refielder tool identifies address components—Name, Postal Address, Street Address, and Last Line—and assigns the data to the correct output fields.

You may have address fields that contain names. For example:

ABC Corp.
c/o John Doe
123 Main St.

In this record, the first address field (the second line) contains a name rather than an address. The Address Refielder tool would send "John Doe" to a name output field, and send "123 Main St" to the address output field. Note that you will now have two name output fields—the original name, and the "found" name from the address line.

Many records have both a postal address and a street address, in no particular order. Some examples:

PO BOX 123
123 Main St.

456 Rural Ln
POB 5437

The Address Refielder tool can recognize which of the two addresses is the street address and which is the postal address, and send each to the appropriate output field.

Address Refielder tool configuration parameters

The Address Refielder tool has one set of configuration parameters in addition to the standard execution options:

Inputs

Field	Names of input fields.
Name	If selected, the associated field may contain a name.
Postal	If selected, the associated field may contain a mailing address.
Street	If selected, the associated field may contain a street address.
Last-line	If selected, the associated field may contain an address last-line.

Outputs

Name	Output field for name. This is optional, and defaults to `OUTPUT_NAME` with a field size of 48.
Postal	Output field for postal address. This is optional, and defaults to `OUTPUT_ADDR_POSTAL` with a field size of 64.
Use street address if no postal address found	If selected, assigns street addresses to missing postal address fields.
Street	Output field for street address. This is optional, and defaults to `OUTPUT_ADDR_STREET` with a field size of 64.
Use postal address if no street address found	If selected, assigns postal addresses to missing street address fields.
Last-line	Output field for the address last-line. This is optional, and defaults to `OUTPUT_LAST` with a field size of 42.

Configure the Address Refielder tool

Select the Address Refielder tool, and then go to the Configuration tab on the Properties pane.
In the Inputs section, specify input fields and the address element or elements each field may contain. You can specify input fields in any order.

For most accurate results, check only those address elements—Name, Postal Address, Street Address, and Last Line — that a field is likely to contain.

In the Outputs section, specify output fields for Name, Postal Address, Street Address, and/or Last Line Address. You need specify only those fields you are refielding.

If the required output fields do not already exist in the input record, new output fields will be created, with the names and field sizes listed below. If the output fields already exist in the input record, they must be large enough to handle the standard size of the components as specified below, or results may be truncated:

Default output field name	Default field size
OUTPUT_NAME	48
OUTPUT_ADDR_DELIVERY	64
OUTPUT_ADDR_LAST	42

To assign street addresses to missing postal address fields, check Use street address if no postal found. To assign postal addresses to missing street address fields, check Use postal address if no street found.
Optionally, go to the Execution tab, and then set Web service options.