View source for Split

Split(''string''[, ''delimiter''[, ''count''[, ''compare'']]])

== Description ==

Split returns a one-dimensional array of strings of a specified length, created by dividing a single string where a specified delimiter occurs. The required parameter, ''string'', is a valid string expression; if ''string'' is a zero-length string (""), a single-element array containing the entire expression string is returned. The optional argument, ''delimiter'', is a string expression whose first character is used to separate the substrings; if not specified, ''delimiter'' defaults to a space character; if ''delimiter'' is a zero-length string (""), a single-element array containing the entire string is returned. The optional parameter, ''count'', is a numeric expression that specifies the number of substrings to return; if ''count'' is not provided -1 is used as a default specifying that all substrings be returned. The optional parameter, ''compare'', is used to specify the type of search performed.

'''Table: Comparison constants'''

{| class="wikitable"
|-
! Constant !! Value !! Description
|-
| vbBinaryCompare || 0 || Binary comparison case sensitive (default)
|-
| vbTextCompare || 1 || Textual comparison, case insensitive
|}

== Example (Basic) ==

<pre>
Rem Split Example
'Split divides a string into substrings
Dim List, Who, All, TopTwo
List = "Eric,Kenny,Kyle,Stan"
Who = Split(List, ",")
Print Who(0), Who(1), Who(2), Who(3)
All = "First Second Third Fourth Fifth"
TopTwo = Split(All, " ")
Print TopTwo(0), TopTwo(1)
</pre>

== Example (JavaScript) ==
<pre>
// Split Example
/* Split divides a string into substrings */

var List, Who, All, TopTwo;
List = "Eric,Kenny,Kyle,Stan";
Who = List.split(",");
NSB.Print(Who[0] + " " + Who[1] + " " + Who[2] + " " + Who[3]);
All = "First Second Third Fourth Fifth";
TopTwo = All.split(" ");
NSB.Print(TopTwo[0] + " " + TopTwo[1]);
</pre>

== Output ==

<pre>
Eric          Kenny  Kyle          Stan
First  Second
</pre>

== Related Items ==

[[join|Join]]

[[Category:Language Reference]]

[[Category:Strings]]