VBscript

Array

UBound(array name[,the largest dimension of the array])

UBound 讀取指訂的陣列中最大的註標

UBound(arrayX)
returns the largest dimension size

UBound 陣列的極大( Up Bound)
LBound 陣列的極小(Low Bound)

VBscript

Array

Split(expression[,delimiter[,count[,compare]]])

可將一資料格中的長字串或數據加以分割陣列化,以方便取用

expression 
Required. String expression containing substrings and 
delimiters. If expression is a zero-length string, 
Split returns an empty array, that is, an array with 
no elements and no data.

delimiter 
Optional. String character used to identify substring limits.
If omitted, the space character (" ") is assumed to be 
the delimiter. If delimiter is a zero-length string, 
a single-element array containing the entire 
expression string is returned.

count 
Optional. Number of substrings to be returned; -1 indicates 
that all substrings are returned.

compare 
Optional. Numeric value indicating the kind of comparison 
to use when evaluating substrings. See Settings 
section for values
vbBinaryCompare : 0 : Perform a binary comparison. 
vbTextCompare : 1 : Perform a textual comparison.
----- compare setting not often use -----
often only use like this::
Split(expression[,delimiter])

最常使用的模式為 :: Split(expression[,delimiter])

VBscript

Array

Filter(Input Strings,value[,include[,compare]])

過濾出所含某特定元素並組成陣列

Filter(Input Strings,value[,include[,compare]])

Input Strings : The main strings
Value : to be searched value
Include : [ True ::( Default ) the array  contains value ]  
[ False :: the array that does not contain value ]
compare :optional
Numeric value indicating the kind of comparison 
to use when evaluating substrings. See Settings 
section for values
comparison same as Split
vbBinaryCompare : 0 : Perform a binary comparison 
vbTextCompare : 1 : Perform a textual comparison