When you think ASP, think...
Recent Articles
All Articles
ASP.NET Articles
Related Web Technologies
User Tips!
Coding Tips

Sample Chapters
JavaScript Tutorials
MSDN Communities Hub
Official Docs
Stump the SQL Guru!
XML Info
Author an Article

The 4 Guys Present: ASPFAQs.com

Jump to a FAQ
Enter FAQ #:
..or see our 10 Most Viewed FAQs.

4GuysFromRolla.com : ASP FAQS : Strings


How can I convert a string into an array?

[Print this FAQ]

Answer: There are oftentimes when you will have a string with a set delimiter, and you may wish to break up the string, stuffing the values between each delimiter into elements in an array. While this task may sound difficult, it is rather quite simple with VBScript.

VBScript provides a function called split, which, as the name implies, splits up a string into an array based on a delimiter. split can only split up a single-dimension array.

Imagine that you had the following string:
How are you doing today?

What if you wanted to use the space as a delimiter, putting each word into an element of an array? With the split function, this is quite simple:

Dim strSentence
strSentence = "How are you doing today?"

Dim aSentence
aSentence = split(strSentence, " ")

At the conclusion of the above code snippet, aSentence is an array with five elements: How, are, you, doing, and today?.

With a bit of ingenuity, you can use the split function to accomplish some really powerful and useful tasks with incredibly few lines of code. For example, you can perform batch database updates and batch database deletes using multiple checkboxes, the split function, and some nifty SQL syntax. To learn more, be sure to read: Using Forms to Do Batch Database Updates and Using SQL Set Notation to do Batch Deletes!

split has an inverse function, one that does the opposite. This function, join, converts an array into a string. To learn more about join, be sure to read the FAQ: How can I convert the contents of an array into a string?

For more preliminary information on split, be sure to read: Parsing with join and split.

Happy Programming!

FAQ posted by Scott Mitchell at 11/27/2000 3:53:51 AM to the Strings category. This FAQ has been viewed 65,198 times.

Do you have a FAQ you'd like to suggest? Suggestions? Comments? If so, send it in! Also, if you'd like to be a FAQ Admin (creating/editing FAQs), let me know! If you are looking for other FAQs, be sure to check out the 4Guys FAQ and Commonly Asked Messageboard Questions!

Most Viewed FAQs:

1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. (761643 views)
2.) I am using Access and getting a 80004005 error (or a [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem? (207777 views)
3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? (202549 views)
4.) How can I quickly sort a VBScript array? (196039 views)
5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. (156019 views)
6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... (152331 views)
7.) When I get a list of all files in a directory via the FileSystemObject, they aren't ordered in any reasonable way. How can I sort the files by name? Or by size? Or by date created? Or... (140381 views)
8.) For session variables to work, must the Web visitor have cookies enabled? (110162 views)
9.) Can I send emails without using CDONTS? (107083 views)
10.) How can I take the result of a SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? (106308 views)
Last computed at 9/17/2007 3:22:00 AM

ASP.NET [1.x] [2.0] | ASPFAQs.com | Advertise | Feedback | Author an Article