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?
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
|