Sun Chili!Soft ASP Sun Chili!Soft
ASP Sun Microsystems


VBScript Split Function

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

Syntax: VBScript Split Function

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


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.


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.


The number of substrings to be returned; -1 indicates that all substrings are returned. Optional.


The numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. Optional.

Settings: VBScript Split Function

The compare argument can have the following values:






Perform a binary comparison.



Perform a textual comparison.

Remarks: VBScript Split Function

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, Msg

MyString = "VBScriptXisXfun!"

MyArray = Split(MyString, "x", -1, 1)

' MyArray(0) contains "VBScript".

' MyArray(1) contains "is".

' MyArray(2) contains "fun!".

Msg = MyArray(0) & " " & MyArray(1)

Msg = Msg   & " " & MyArray(2)

MsgBox Msg

Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.