7,763
社区成员
发帖
与我相关
我的任务
分享
With CreateObject("vbscript.regExp")
.Pattern = "button\d+"
MsgBox .Replace("lksf78932button78959dkopoek", "button33333")
End With
Private Sub Command1_Click()
Dim strTemp As String
strTemp = "lksf78932button78959dkopoek"
MsgBox Mid(strTemp, 1, InStr(1, strTemp, "button") + 5) & "33333" & Mid(strTemp, InStr(1, strTemp, "button") + 11)
End Sub
Private Sub TestReg()
Dim strData As String
Dim reg As Object
strData = "lksf78932button78959dkopoek" & vbCrLf & _
"b78932diiwlbutton66959ooppppe" & vbCrLf & _
"aa78932diiwlbutton54959lockue"
Set reg = CreateObject("vbscript.regExp")
reg.Global = True
reg.IgnoreCase = True
reg.MultiLine = True
reg.Pattern = "button\d+"
Debug.Print reg.Replace(strData, "button33333")
End Sub
Private Sub TestReg()
Dim strData As String
Dim reg As Object
strData = "lksf78932button78959dkopoek" & vbCrLf & _
"b78932diiwlbutton66959ooppppe" & vbCrLf & _
"aa78932diiwlbutton54959lockue"
Set reg = CreateObject("vbscript.regExp")
reg.Global = True
reg.IgnoreCase = True
reg.MultiLine = True
reg.Pattern = "(.+?button)(\d+)(.+?)"
Debug.Print reg.Replace(strData, "$133333$3")
End Sub