Parse a string of delimited values into an array.
Syntax Split(expression [,Delimiter [,count [,compare]]] ) Key expression The string expression to be broken up into an array. Delimiter The character used to separate items (default=a space " ") count The number of strings compare vbBinaryCompare (0) or vbTextCompare(1)
Create an array from a comma separated list of prices:
arrPrices = Split("23.50, 67.50, 45.99, 18.47", ",") WScript.Echo arrPrices(0) > 23.50
Script to open the file quotes.txt and split it on each line ending, returning one quote of the day:
' ' run this with: ' cscript fortune.vbs quotes.txt > quote-of-the-day.txt //nologo ' Set objFS = CreateObject("Scripting.FileSystemObject") Set strFileContent = objFS.OpenTextFile(WScript.Arguments(0)) arrQuotes = Split(strFileContent.ReadAll, vbCrLf) Randomize Timer WScript.Echo arrQuotes(Round(Rnd * UBound(arrQuotes)))
“A gentle stream can split a mountain, given enough time”
Array - Add values to an Array variable.
Join - Combine the contents of an array into a single variable.
Equivalent in PowerShell: .Split method.