Split
This function creates a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression, [delimiter], [count], [compare])
Parameters
- expression
- Required. String expression that contains 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.
- delimiter
- Optional. 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.
- count
- Optional. Number of substrings to be returned; –1 indicates that all substrings are returned.
- compare
- Optional. Numeric value that indicates the kind of comparison to use when evaluating substrings. The following table shows the possible values for the compare parameter.
Constant
|
Value
|
Description
|
| vbBinaryCompare |
0 |
Perform a binary comparison. |
| vbTextCompare |
1 |
Perform a textual comparison. |
| vbDatabaseCompare |
2 |
Not supported. |
Return Values
Returns a zero-based, one-dimensional array.
Remarks
Use the Join function to create a string to split.