VBScript Split Function
❮ Complete VBScript Reference
The Split function returns a zero-based, one-dimensional array that contains a specified number of substrings.
Syntax
Split(expression[,delimiter[,count[,compare]]])
| Parameter | Description |
|---|---|
| expression | Required. A string expression that contains substrings and delimiters |
| delimiter | Optional. A string character used to identify substring limits. Default is the space character |
| count | Optional. The number of substrings to be returned. -1 indicates that all substrings are returned |
| compare | Optional. Specifies the string comparison to use. Can have one of the following values:
|
Examples
Example 1
<%
a=Split("W3Schools is my favourite website")
for each x in a
response.write(x & "<br />")
next
%>
a=Split("W3Schools is my favourite website")
for each x in a
response.write(x & "<br />")
next
%>
The output of the code above will be:
W3Schools
is
my
favourite
website
Show Example »
is
my
favourite
website
Example 2
Splitting the text using the delimiter parameter
<%
a=Split("Brown cow, White horse, Yellow chicken",",")
for each x in a
response.write(x & "<br />")
next
%>
a=Split("Brown cow, White horse, Yellow chicken",",")
for each x in a
response.write(x & "<br />")
next
%>
The output of the code above will be:
Brown cow
White horse
Yellow chicken
Show Example »
White horse
Yellow chicken
Example 3
Splitting the text using the delimiter parameter, and the count parameter
<%
a=Split("W3Schools is my favourite website"," ",2)
for each x in a
response.write(x & "<br />")
next
%>
a=Split("W3Schools is my favourite website"," ",2)
for each x in a
response.write(x & "<br />")
next
%>
The output of the code above will be:
W3Schools
is my favourite website
Show Example »
is my favourite website
Example 4
Splitting the text using the delimiter parameter with a textual comparison:
<%
a=Split("SundayMondayTuesdayWEDNESDAYThursdayFridaySaturday","day",-1,1)
for each x in a
response.write(x & "<br />")
next
%>
a=Split("SundayMondayTuesdayWEDNESDAYThursdayFridaySaturday","day",-1,1)
for each x in a
response.write(x & "<br />")
next
%>
The output of the code above will be:
Sun
Mon
Tues
WEDNES
Thurs
Fri
Satur
Show Example »
Mon
Tues
WEDNES
Thurs
Fri
Satur
Example 5
Splitting the text using the delimiter parameter with a binary comparison:
<%
a=Split("SundayMondayTuesdayWEDNESDAYThursdayFridaySaturday","day",-1,0)
for each x in a
response.write(x & "<br />")
next
%>
a=Split("SundayMondayTuesdayWEDNESDAYThursdayFridaySaturday","day",-1,0)
for each x in a
response.write(x & "<br />")
next
%>
The output of the code above will be:
Sun
Mon
Tues
WEDNESDAYThurs
Fri
Satur
Show Example »
Mon
Tues
WEDNESDAYThurs
Fri
Satur
❮ Complete VBScript Reference