Returns an array that contains substrings.

Use this function to parse strings that contain substrings separated by a character such as a comma (,). For example, the lines of an address are often separated by a comma.

If <value> is an empty string, the return value is an empty array. Otherwise, if Delimiter is an empty string or is not found in Val, the return value is an array containing one item, a copy of <value>. If the current data value is NULL, <value> is an empty string and the return value is an empty array.

The Split function returns a categorical value, making it impossible to assign elements of the returned array. The result from the Split function is not a real categorical value, because the elements of a categorical must be of type Long (int - VT_I4), not text. The parser treats the value as a categorical, but an error is returned when trying to pass the value into a function that expects a real categorical (ContainsAny for example).

The following mrScriptBasic example returns the first line and the first two lines of an address that is stored in a single variable with the lines separated by commas. It also shows an example of using the function using the default parameters: