The Parse Address tool breaks down a street address into its component
parts, such as street number, directional (S, NW, and so on), street name,
and suffix (ST, RD, BLVD).
The tool can also parse Last Line data (city, state, and ZIP Code) into
the separate parts. This is handy if your address data comes to you as
lines of plain text instead of discrete fields.
The CASS Address Parse Tool uses the CASS library, a separate data install
that is only available with the Alteryx Spatial offering. It requires a special license to run.
Any address field can
be passed through this tool. While the CASS library installation is required,
you do not
have to run it through the CASS Tool to parse the
address data.
Configure the tool
Specify
the Address field to parse
using the dropdown list.
Specify
the Last Line field to parse
using the dropdown list. This is an Optional field.
Check
the Parse Canadian Addresses
checkbox only if your input contains Canadian Addresses.
Choose
to output a single parsed candidate or to output all parsed candidates.
Output
Single Parse Candidate: Each record gets parsed and a single
record is returned. This option typically returns the best parse
candidate, but may not when there are multiple candidates.
Output
All Parse Candidates: Each record gets parsed and every
possible parse candidate gets returned, meaning a record may have
multiple ways of being parsed and each method becomes its own
record on output.
Select
the Output Fields to return
using the checkbox to the left of the field name. The All, US Default,
CA Default, and Clear Button should help with making multiple selections.
Output fields are defined below:
CASSParse_City:
The city name is returned only
if the "Last Line" field is specified in step 2.
CASSParse_Garbage:
Any garbage characters left
over after the address has been parsed. The returned value is
a maximum 50-character string. Common items found in this
field are community center names, names of individuals, or additional
delivery instructions.
CASSParse_Plus4:
The plus 4 extension of the
ZIP Code is returned if the "Last Line" field is specified
in step 2.
The CASS Address Parse
tool does NOT do any address checking. Therefore if the input
address does not contain a recognizable four-digit ZIP add-on,
there will be no value returned in this field.
CASSParse_PostDirection:
The geographic directional
that follows the street name. The value is returned as a maximum
2-character string. Directions such as "North" will
be changed to "N" in the outputted field.
CASSParse_PreDirection:
The geographic directional
that precedes the street name is returned. The value is returned
as a maximum 2-character string. Longer values are truncated.
CASSParse_PrivateMailboxName:
The private mailbox number
portion is returned if the input address contains the "PMB"
abbreviation.
CASSParse_PrivateMailboxNumber:
The private mailbox name portion
is returned if the input address contains the "PMB"
abbreviation.
CASSParse_Range:
The delivery number of the
parsed address is returned. The value is returned as a maximum
10-character string.
CASSParse_State:
The state name abbreviation
is returned if the "Last Line" field is specified in
step 2.
CASSParse_StreetName:
The name of the street is returned.
The value is returned as a maximum 28-character string.
CASSParse_Suffix:
The suffix portion of an address
is returned. The value is returned as a maximum 4-character string. Typical
Suffix values include "ST", "RD", and "AVE".
CASSParse_SuiteName:
The name of the secondary
unit is returned. The value is returned as a maximum 4-character
string containing the suite name portion of the full input address. Typical
Suite Name values include â#â, âAPTâ, âBLDGâ, and âSTEâ.
CASSParse_SuiteNumber:
The range of any secondary
unit is returned. The value is returned as a maximum 6-character
string containing the suite number portion of the full input address.
CASSParse_Zip:
The ZIP Code is returned if
the "Last Line" field is specified in step 2.
CASSParse_CA_DeliveryInstallation:
Canada Addresses only - The
Delivery Installation information is returned. The delivery installation
is the post office facility responsible for delivering to the
current address. It is often used for rural addresses or when
multiple post offices service the same municipality.
CASSParse_CA_LockBox:
Canada Addresses only - The
lock box information is returned. A lock box is the Canadian equivalent
of a Post Office Box in the US. The two terms are used interchangeably
in Canada.
CASSParse_CA_RouteService:
Canada Addresses only - The
route service information is returned. The route service is a
term used to refer to what the USPS would call a Rural Route address.
Parse Address Tool