<%
'欄位內網址加上聯結。
Function ToLink(Str)
Dim RE 'Regex對象 Dim strContent
If IsNull(Str) Then Str = ""
Set RE = New RegExp '建立正 則運算式對象
With RE
.Global = True '搜尋應用於整個字串
.IgnoreCase = True '搜尋不區分大小寫
strContent = Str
'***************************************************************
'郵件地址連結自動化佈建
'***************************************************************
.Pattern = "([\w]*)@([\w\.]*)"
strContent = .Replace(strContent, "<A Href='mailto:$1@$2'>$1@$2</A> ")
'***************************************************************
'連結自動化佈建
'***************************************************************
'======根據要求再添加協議名稱=======
Dim D(3), I
D(0) = "http"
D(1) = "ftp"
D(2) = "news"
D(3) = "mms"
'===================================
For I = 0 To UBound(D)
.Pattern = D(I) + ":\/\/([\w\.]*)"
strContent = .Replace(strContent, "<A Href='" + D(I) + "://$1' target=_blank>" + D(I) + "://$1</A> ")
Next
'***************************************************************
End With
Set RE = Nothing
ToLink = strContent
End Function
%>
