W3Schools.com

VBScript Split Function

VBScript Reference 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:

  • 0 = vbBinaryCompare - Perform a binary comparison
  • 1 = vbTextCompare - Perform a textual comparison

Examples

Example 1

<script type="text/vbscript">

a=Split("W3Schools is my favourite website")
for each x in a
    document.write(x & "<br />")
next

</script>

The output of the code above will be:

W3Schools
is
my
favourite
website

Try it yourself »

Example 2

Splitting the text using the delimeter parameter

<script type="text/vbscript">

a=Split("Brown cow, White horse, Yellow chicken",",")
for each x in a
    document.write(x & "<br />")
next

</script>

The output of the code above will be:

Brown cow
White horse
Yellow chicken

Try it yourself »

Example 3

Splitting the text using the delimeter parameter, and the count parameter

<script type="text/vbscript">

a=Split("W3Schools is my favourite website"," ",2)
for each x in a
    document.write(x & "<br />")
next

</script>

The output of the code above will be:

W3Schools
is my favourite website

Try it yourself »

Example 4

Splitting the text using the delimeter parameter with a textual comparison:

<script type="text/vbscript">

a=Split("SundayMondayTuesdayWEDNESDAYThursdayFridaySaturday","day",-1,1)
for each x in a
    document.write(x & "<br />")
next

</script>

The output of the code above will be:

Sun
Mon
Tues
WEDNES
Thurs
Fri
Satur

Try it yourself »

Example 5

Splitting the text using the delimeter parameter with a binary comparison:

<script type="text/vbscript">

a=Split("SundayMondayTuesdayWEDNESDAYThursdayFridaySaturday","day",-1,0)
for each x in a
    document.write(x & "<br />")
next

</script>

The output of the code above will be:

Sun
Mon
Tues
WEDNESDAYThurs
Fri
Satur

Try it yourself »
VBScript Reference Complete VBScript Reference
WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$7.95/mo SEO Hosting
Premium Website Design
WEB BUILDING
XML Editor - Free Trial!
FREE Website BUILDER
Free Website Templates Free CSS Templates
Make Your Own Website
W3SCHOOLS EXAMS
Get Certified in:
HTML, CSS, JavaScript, XML, PHP, and ASP
W3SCHOOLS BOOKS
New Books:
HTML, CSS
JavaScript, and Ajax
STATISTICS
Browser Statistics
Browser OS
Browser Display
SHARE THIS PAGE