8.4.71 Split Function

Returns a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression[, delimiter[, count[, compare]]])
- expression
- A string expression containing substrings and delimiters. If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data. Required.
- delimiter
- A string character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned. Optional.
- count
- The number of substrings to be returned; -1 indicates that all substrings are returned. Optional.
- compare
- The numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. Optional.
Settings
The compare argument can have the following values:
Constant
|
Value
|
Description
|
vbBinaryCompare
|
0
|
Perform a binary comparison.
|
vbTextCompare
|
1
|
Perform a textual comparison.
|
Copyright © 2000 Chili!Soft
|