Starts from the left and splits a column into two or more columns, depending on a separator you define. The separator may be a single character or substring.
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.
Select From Right by Delimiter.
Enter the separator into Split Delimiter.
Enter the value of click in Column Count to define the number of columns that the field will be split.
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:
Check the Remove Original Column box to delete the original column and just display the split columns instead.
Click OK. The new columns from the split are displayed.