Splits a text column into multiple text columns using specified character delimiters.

Syntax:

SplitTextColumn, columnID, delimiters

Parameters:

columnID - the text column caption or index to be split

delimiters - a character or set of characters to be used to split the column. 

Examples:

NewTextColumnName,Period,Year/Month/Day
SplitTextColumn,Year/Month/Day,/

This example renames the text column "Period" to "Year/Month/Day" then splits it into columns using the character "/". The result is three columns labelled "Year", "Month" and "Day" (the column caption is split as well).   If the column contained "2008/10/02", it would be split to "2008", "10", "02" accordingly.

Comments:

Multiple characters can be specified, and the occurence of any of them in any order will be used to split the column.