Delimiter
可选项。在返回字符串中用于分隔子字符串的字符。如果省略，将使用空字符 ("")。如果 delimiter 是零长度字符串，则在同一列表中列出全部项，没有分界符。
下面的示例利用 Join 函数联合 MyArray 的子字符串：
| Dim MyString Dim MyArray(3) MyArray(0) = "Mr." MyArray(1) = "John " MyArray(2) = "Doe " MyArray(3) = "III" MyString = Join(MyArray) 'MyString 包含 "Mr. John Doe III"。 再如： arr = array("t1","t2","t3") MsgBox Join(arr,",") |
上面主要对VBS中的相关函数进行了介绍，在实际工作中还经常会遇到一些特殊的处理，并且都十分的实用，下面一一进行举例说明：
例一：一维数组的比较
| Dim a Dim b a=Array(10,15,30) b=Array(10,20,30) flag=1 For i=0 To UBound(a)-LBound(a) If a(i)=b(i) Then flag=1 Else flag=0 n=UBound(a) msgbox "数组a"&n&":="&a(i)&","&"数组b"&n&":="&b(i) End If Next |
例二：二维数组的比较
| Dim array1(1,1) array1(0,0)=1 array1(0,1)=2 array1(1,0)=3 array1(1,1)=4 Dim array2(1,1) array2(0,0)=1 array2(0,1)=2 array2(1,0)=4 array2(1,1)=4 flag=1 For i=0 To 1 For j=0 To 1 If array1(i,j)=array2(i,j) Then flag=1 Exit for Else flag=0 msgbox "array1"&"("&i&","&j&")"&"="&array1(i,j)&","&"array2"&"("&i&","&j&")"&"="&array2(i,j) End If Next Next |
例三：使用循环来比较数组里是否包含某值
| Dim arr, i, str arr = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, "a", "b", "c", "d", "f", "g") str = "a" For i = 0 To UBound(arr) If arr(i) = str Then Exit For end if Next If i <= UBound(arr) Then msgbox "arr中包含str的值！" Else msgbox "arr中不包含str的值！" End If |
例四：使用函数组合来比较数组里是否包含某值（优化逻辑）
| Dim arr, i, str arr = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, "a", "b", "c", "d", "f", "g") str = "a" If InStr(Join(arr, "|"), str) > 0 Then msgbox "arr中包含str的值！" Else msgbox "arr中不包含str的值！" End If |
灵活应用各种函数命令，可以节约大量的多余代码，不仅精简代码结构，提供执行效率。
例五：VBS中数组作为函数的返回值
| Function GenerateRandom() Dim myarray(2) Dim aa, bb, cc Dim myvalue, bbbase, ccbase bbbase=array("Beijing", "NewYork", "Copenhagen", "Paris", "London", "Gothenborg") ccbase=array("China", "America", "Denmark", "Franch", "England", "Sweden") 'Get a number contains 8 characters aa= Int((99999999 - 11111111+ 1) * Rnd + 11111111) ' Get a number between 1 to 6 myvalue=Int((6 * Rnd) + 1) bb=bbbase(myvalue) cc=ccbase(myvalue) myarray(0)=CStr(aa) myarray(1)=bb myarray(2)=cc GenerateRandom=myarray End Function '**************************************************** ' Call the function Dim testarr testarr=GenerateRandom msgbox testarr(0) msgbox testarr(1) msgbox testarr(2) |
