VBScript Split Function

## VBScript Tutorial

VB HOME VB How to VB Variables VB Procedures VB Conditional VB Looping VB Summary

## VB Examples

VB Examples

## VB References

VB Functions VB Keywords

# 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:

- 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 »

Complete VBScript Reference

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE