Sub demo()
'想使用正则表达式进行数据处理,但是调试的时候到正则submatches时候说对象不适用该属性或方法,这是为什么呢?
给了s和用正则编辑器的结果,正则表达式应该对的
Worksheets("Sheet2").Activate
Dim s As String, myreg As Object, reg1 As Object, myreg1 As Object, i As Integer
i = 2
s = Worksheets("Sheet3").Cells(1, 1)
Set myreg = CreateObject("VBscript.regexp")
With myreg
.Global = True
.Pattern = "预订\|.*?\|(.*?)\|(?:.*?\|){4}(.*?)\|(.*?)\|(.*?)\|(?:.*?\|){19}(.*?)\|(.*?)\|(.*?)\|"
End With
Set reg1 = myreg.Execute(s)
For Each myreg1 In reg1
Cells(i, 1) = reg1.submatches(0)
Cells(i, 2) = reg1.submatches(1)
Cells(i, 3) = reg1.submatches(2)
Cells(i, 4) = reg1.submatches(3)
Cells(i, 7) = reg1.submatches(4)
Cells(i, 6) = reg1.submatches(5)
Cells(i, 5) = reg1.submatches(6)
i = i + 1
Next myreg1