Splitting a Column

After transforming a column with inconsistent date formats, you can split it into several columns.

Prerequisites

This example shows how to split the transformed DOB column to create a month column.

From the DOB column menu, click Edit column > Split into several columns.
In the Separator field, enter /, and then click OK.
Three columns, DOB 1, DOB 2, and DOB 3 are created that display the day, month, and year data.
Remove the DOB 1 and DOB 3 columns:
1. From the DOB 1 column menu, click Edit column > Remove this column.
2. From the DOB 3 column menu, click Edit column > Remove this column.
Rename the DOB 2 column. Double click the column name DOB 2, and then enter Month.