Split Personal Name

Splits the value of a single name column into its component name parts.

Split Personal Name

1. You can either:

• • right-click on a Text field

  • click the drop down of a Text field

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

The Split dialog displays.

2. Select Personal Name.

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

3. 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:

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

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

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