所以我在VBA上使用了一个正则表达式函数来提取5位数。到目前为止,我所拥有的对我来说是有效的。
它提取5位数字,如'12345‘或字母数字字符,如'a12345’。但是,我希望它提取5个数字字符,我们将知道前2个数字是什么,例如12xxx或45xxx。
我该如何指定前两位数?
Function Digits(r As String) As String
Dim m
With CreateObject("vbscript.regexp")
.Pattern = "\b\d{5}\b|^(?![0-9]{6})[0-9a-zA-Z]{6}$"
.Global = False
If Not .test(r) Then Exit Function
For Each m In .Execute(r)
Multi5 = Multi5 & m & ", "
Next
Digits = Left(Digits, Len(Digits) - 2)
End With
End Function发布于 2021-03-29 23:51:29
将.Global = False修改为.Global = True
Function Digits(r As String) As String
Dim m As Object, matchs As Object
With CreateObject("vbscript.regexp")
'.Pattern = "\b\d{5}\b|^(?![0-9]{6})[0-9a-zA-Z]{6}$"
.Pattern = "12\d{3}"
.Global = True
If Not .test(r) Then Exit Function
Set matchs = .Execute(r)
For Each m In matchs
multi5 = multi5 & m & ", "
Next
Digits = Left(multi5, Len(multi5) - 2)
End With
End Functionhttps://stackoverflow.com/questions/66855959
复制相似问题