Microsoft® Visual Basic® Scripting Edition Split Function | Language Reference Version 2

See Also

##### Description

> Returns a zero-based, one-dimensional array containing a specified number of substrings.

##### Syntax

> Split(expression[, delimiter[, count[, compare]]])

> The Split function syntax has these parts:

> Part | Description
> expression | Required. 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.
> 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 indicating the kind of comparison to use when evaluating substrings. See Settings section for values.

##### Settings

> The compare argument can have the following values:

> Constant | Value | Description
> vbBinaryCompare | 0 | Perform a binary comparison.
> vbTextCompare | 1 | Perform a textual comparison.

##### Remarks

> The following example uses the Split function to return an array from a string. The function performs a textual comparison of the delimiter, and returns all of the substrings.

> >     Dim MyString, MyArray
> >     MyString = Split("VBScriptXisXfun!", "x", -1, 1)
> >     ' MyString(0) contains "VBScript".
> >     ' MyString(1) contains "is".
> >     ' MyString(2) contains "fun!".

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.