ASP: the split function and arrays

The ASP split function is used to - guess what - split a string into specific parts. The resulting number of items is variable and depends on how we use the function.
Basically the split function has the following syntax:
VarArray = split(string, delimiter, numberOfItems)
where:
1) string is the string to be split;
2) delimiter is the element used to determine where to split the string;
3) numberOfItems is optional and limits the number of returned items in the array.

Let's see some examples.
<%
Dim VarString
Dim VarArray
VarString = "Welcome to The Web Thought!"
VarArray = split(VarString, " ")
For each item in VarArray
  response.write(item & "
")
Next
%>
The output of the above code will be:
Welcome
to
The
Web
Thought!
If we change the split function and add a limit to the number of items in the array:
split(VarString, " ", 3)
the output will be:
Welcome
to
The Web Thought!
Having said that, the split function might become very useful if we need to store dynamic information in a database and retrieve them storing them in an array. We can, for example, store a list of available colour codes for a specific product, separating them by a semicolon:
A1;A2;A3;A4
then we can store the recordset field item in a string and split it using ";" as delimiter:
VarArray = split("A1;A2;A3;A4", ";")
The output will be:
A1
A2
A3
A4

I hope you've found the above information useful for your projects. In the meantime, happy programming!