DevGuru VBScript Function: Split

Quick References

Features

Partners

FUNCTION: Split( )

Split(Expression, Delimiter, Count, Compare)

The Split function separates a string into substrings and creates a one-dimensional array where each substring is an element.

There is one mandatory argument.

Expression

The Expression argument is a string expression.

Code:
<% mystring = "How now brown cow?" %>
<% myarray = Split(mystring) %>
<% =myarray(0) %>
<% =myarray(1) %>
<% =myarray(2) %>
<% =myarray(3) %>

Output:
How
now
brown
cow?

There are three optional arguments.

Delimiter

The optional Delimiter argument specifies the characters (including blanks) you wish to use to separate the expression. The default is a single empty space, " ".

Code:
<% mystring = "How now brown cow?" %>
<% myarray = Split(mystring, "ow") %>
<% =myarray(0) %>
<% =myarray(1) %>
<% =myarray(2) %>
<% =myarray(3) %>
<% =myarray(4) %>

Output:
H
n
br
n c
?

Count

The optional Count argument specifies the number of elements to return.

Code:
<% mystring = "How now brown cow?" %>
<% myarray = Split(mystring, " ", 2) %>
<% =myarray(0) %>
<% =myarray(1) %>

Output:
How
now brown cow?

Compare

The optional Compare argument must only use the constant or value of the COMPARISON CONSTANTS.

CONSTANT	VALUE	DESCRIPTION
VBBinaryCompare	0	Binary comparison
VBTextCompare	1	Text Comparison
VBDataBaseCompare	2	Compare information inside database

In the example, by using VBTextCompare for the Compare argument, the split occurs at the b and ignores the upper case difference between the Delimiter argument "B".

Code:
<% mystring = "How now brown cow?" %>
<% myarray = Split(mystring, "B", 2, 1) %>
<% =myarray(0) %>
<% =myarray(1) %>

Output:
How now
rown cow?

Code:
<% mystring = "How now brown cow?" %>
<% myarray = Split(mystring, "B", 2, VBTextCompare) %>
<% =myarray(0) %>
<% =myarray(1) %>

Output:
How now
rown cow?