AO Parsing Assistant
Overview
Advanced Object (AO) Parsing Assistant is an all-in-one macro designed to parse, standardize, and normalize common data elements.
This macro requires that the CASS address standardization module be licensed and installed in order to run.
AO Parsing Assistant configuration parameters
AO Parsing Assistant has two sets of configuration parameters: Input and Settings.
AO Parsing Assistant Input tab
Company / institution
Parameter | Description |
|---|---|
Business name | Field containing company name.
|
Name
Parameter | Description |
|---|---|
First | Field containing given name (John A Smith Jr).
|
Mid | Field containing middle name (John A Smith Jr).
|
Last | Field containing surname (John A Smith Jr).
|
Suffix | Field containing generation name (John A Smith Jr).
|
Address
Parameter | Description |
|---|---|
Address1 | Field containing first line of unparsed address.
|
Address2 | Field containing second line of unparsed address.
|
City | Field containing city.
|
State | Field containing state.
|
ZIP | Field containing ZIP Code.
|
Lastline | Field containing city, state, and ZIP Code.
|
Other
Parameter | Description |
|---|---|
Phone | Field containing telephone number field.
|
Field containing consumer email address.
| |
SSN | Field containing Social Security Number.
|
URL | Field containing web address. Alternate input field can be specified.
|
AO Parsing Assistant Settings tab
Name options
Parameter | Description |
|---|---|
Capitalization | Controls the capitalization of name output data.
|
Reparse name | Select to combine parsed name input into a string and parse again.
|
Address options
Parameter | Description |
|---|---|
Capitalization | Controls the capitalization of CASS output data.
|
Geocode | Specifies whether to geocode the address, and if so, which geocode to use: Geocoder, or the CASS ZIP4 Centroid (output by the Standardize Address tool).
|
Phone options
Parameter | Description |
|---|---|
Output phone format | Select the format for valid standardized phone number. Defined formats are:
|
Configure AO Parsing Assistant
Select AO Parsing Assistant.
Go to the Input tab on the Properties pane.
Specify Company, Name, Address, and Other fields to be parsed.
Optionally, select the Settings tab and edit Name, Address, and Phone options.
Optionally, go to the Execution tab, and then set Web service options.