VBScript 字串是不可變的,str = str & "something" 每次都會配置新記憶體、複製舊內容。迴圈中大量串接會導致 O(n²) 效能災難。Join(ary, delim) 只需一次記憶體配置,效能接近 C/PHP 的 implode。
Join(oneDimArray[, delimiter])
' delimiter 省略預設為空字串 "" (無分隔符)
' delimiter = "" 時直接連接所有元素
<%
Dim days(5), filtered, result
days(0) = "Saturday"
days(1) = "Sunday"
days(2) = "Monday"
days(3) = "Tuesday"
days(4) = "Wednesday"
days(5) = "Thursday"
' Filter 篩選包含 "n" 的元素
filtered = Filter(days, "n") ' 回傳 Array("Sunday","Monday","Wednesday")
' Join 合併,預設空分隔
result = Join(filtered) ' "SundayMondayWednesday"
Response.Write result & "
"
' 指定分隔符
result = Join(filtered, ", ") ' "Sunday, Monday, Wednesday"
Response.Write result
%>
<%
Dim arr(10000), i, startTime, result
startTime = Timer
For i = 0 To 10000
arr(i) = CStr(i)
Next
' Join 一次性合併
result = Join(arr, vbCrLf)
Response.Write "Join 耗時: " & FormatNumber(Timer - startTime, 4) & " 秒
"
' 典型輸出: 0.0030 秒
' 對比 & 串接 (註解掉避免超時)
' startTime = Timer
' Dim s : s = ""
' For i = 0 To 10000
' s = s & arr(i) & vbCrLf
' Next
' Response.Write "& 串接耗時: " & FormatNumber(Timer - startTime, 4) & " 秒"
' 典型輸出: 1.2 秒 (慢 400 倍)
%>
' 快速產生 CSV 行
Dim csvLine
csvLine = Join(Array("張三", "25", "台北", "工程師"), ",")
' 結果: "張三,25,台北,工程師"
' 產生 SQL IN 列表 (需自行處理引號)
Dim ids, inClause
ids = Array(101, 102, 103, 104)
inClause = Join(ids, ",")
' inClause = "101,102,103,104"
sql = "SELECT * FROM Users WHERE ID IN (" & inClause & ")"
| 函式 | 方向 | 用途 |
|---|---|---|
| Split | 字串 → 陣列 | 分割 CSV、查詢字串、日誌行 |
| Filter | 陣列 → 陣列 | 篩選含/不含特定子字串的元素 |
| Join | 陣列 → 字串 | 高效串接、產生 CSV/IN 列表/HTML |
<%
Function BuildOptions(values, texts, selectedVal)
Dim htmlArr(), i, cnt
cnt = UBound(values)
ReDim htmlArr(cnt)
For i = 0 To cnt
Dim sel : sel = ""
If CStr(values(i)) = CStr(selectedVal) Then sel = " selected"
htmlArr(i) = ""
Next
BuildOptions = Join(htmlArr, vbCrLf)
End Function
' 使用
Dim vals, txts
vals = Array("", "1", "2", "3")
txts = Array("請選擇", "選項一", "選項二", "選項三")
Response.Write ""
%>
Null 會導致錯誤,建議先 If IsNull(arr(i)) Then arr(i) = ""Filter 回傳的陣列下標從 0 開始連續,可直接 Join