expression | (String) Text string containing substrings and delimiters. If expression is empty string, then the function returns an empty array, i.e. an array with no elements and no data. |
---|---|
delimiter | [optional] (Variant) String character used to identify substring limits.
If not set, then the space character (" ") is assumed to be the delimiter. If is an empty string, then a single-element array containing the entire text string is returned. |
count | [optional] (Integer) The number of substrings to be returned. Value -1 means that all substrings are returned. |
compare | [optional] (Integer) Numeric value specifies the kind of comparison to use when evaluating substrings.
If not set, then a binary comparison is performed. vbBinaryCompare - perform a binary comparison
vbTextCompare - perform a textual comparison |
Dim arr
arr = Split("PROMOTIC:is:fun!", ":")
' arr(0) contains "PROMOTIC"
' arr(1) contains "is"
' arr(2) contains "fun!"