Addresses into Parts

Splits the value of a single address column into its component address or postal parts.

When you apply this transformation, Monarch Data Prep Studio will ask you which of the following name components are available:

Field	Description
Address line 1	Outputs the first line of data extracted from the input information.
Address line 2	Outputs the second line of data extracted from the input information, provided it is not recognized as a City, Region or Postal Code.
Address line 3	Outputs the third line of data extracted from the input information, provided it is not recognized as a City, Region or Postal Code.
Address line 4	Outputs the fourth line of data extracted from the input information, provided it is not recognized as a City, Region or Postal Code.
Address line 5	Outputs the fifth line of data extracted from the input information, provided it is not recognized as a City, Region or Postal Code.
Address line 6	Outputs the sixth line of data extracted from the input information, provided it is not recognized as a City, Region or Postal Code.
City	Outputs the City name extracted from the input information.
Region	Outputs the Region name (State, County, etc) extracted from the input information.
Postal Code	Outputs the Postal Code extracted from the input information.
Country	Outputs the Country name extracted from the input information.
Error Code	Outputs the error code, if any are generated by the Address Block engine when parsing the input information. See Using Address Blocks for more information on Address Block error codes.

Monarch Data Prep Studio will do the postal split depending on the components selected.

Input	Output
text	text

In this example, Address is the original column. It is split into three columns: City, Region, and PostalCode.