Guide Section: Processing Object Data | EASAP Tree: DATA PROCESSING → LIST

SPLIT creates a LIST from a text string by splitting it up into a list of values.

The locations where the string is split are determined by a specified separator found within the string.

SPLIT
Essential Parameters:
Value:	Text string to be split up into a list, object reference allowed
Separator:	Separator character(s) used to determine split locations (e.g. / or ,)
Skip Nulls:	Ignore null values coming from a database.
Optional Parameters:
Delimiter:	Character to delimit object references in Value: (default→%)
Replace Nulls:	Substitute null values in the Value: with this value.

SPLIT is useful for creating a list from the value of a CHOICE LIST that allows multiple selections since the multiple selections are stored comma- separated in a single text string.