|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 ychh_wy 于 2019-3-22 10:50 编辑
'ychh_wy
Function 字符串匹配(字符串1, 字符串2)
If Len(字符串1) = 0 Or Len(字符串2) = 0 Then 字符串匹配 = "未匹配上": Exit Function
If Len(字符串1) >= Len(字符串2) Then
X = 字符串1: C = 字符串2
Else
X = 字符串2: C = 字符串1
End If
For N = 1 To Len(X)
If Mid(X, N, 1) Like "[()]" = False Then C = Replace(C, Mid(X, N, 1), "", 1)
Next
If C = "" Or C Like "(*)" Then
字符串匹配 = "匹配上"
ElseIf C Like "[省市区县乡镇]" Then
字符串匹配 = "匹配上"
Else
字符串匹配 = "待确定"
End If
End Function |
|