Split Postal Address

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

Split Postal Address

  1. You can either:

then select Split... in the context menu that displays.

The Split dialog displays.

  1. Select Postal Address.

The dialog box changes displaying the section for the sample split of the name.

  1. Enter the value or click in Sample Row to select the row number that a sample of the split definition that will be displayed in the Result Column box below:

  1. Check the Type box that you want to use for the split columns.

  1. Check the Remove Original Column box to delete the original column and just display the split columns instead.

  2. Click OK. The new columns of the components selected from the split are displayed.