- Excel Desktop Client new !
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.
|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.|
|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.