PARSEADDR

Description

Returns the specified address line token, from a US-style address line in the format "City, State ZipCode".

Syntax

PARSEADDR ( TextSourceField, "address_token" )

Parameter	Description
TextSourceField	The string from which to return an address token.
address_token	The identifier for the address token to return. Following are the valid values for this argument. C — City S — State Z — Zip Code

Remarks

For consistent results, the address line must follow the US format of City, State ZipCode. For example: Manchester, NH 03104. Other formats may cause unpredictable results. If the data is not in the required format, try using PARSE.

Examples

This function returns NH:

PARSEADDR("Bedford, NH 03032", "S")

This function returns 03024-1245:

PARSEADDR("New Boston, NH 03024-1245", "Z")