|
继续练习正则。
- Sub tt()
- arr = Range("a1:a21")
- With CreateObject("vbscript.regexp")
- .Global = True
- .Pattern = "^(.*?)(?=,).(\d+?)(?=,).(北京市|上海市|重庆市|天津市|.*省|.*自治区)(.*?市|.*?区|.*?州)(.*?县|.*?区|.*?市)?(.*)"
- ReDim brr(2 To UBound(arr), 5)
- For i = 2 To UBound(arr)
- For Each m In .Execute(arr(i, 1))
- For j = 0 To 5
- brr(i, j) = m.submatches(j)
- Next
- Next
- Next
- End With
- Sheets(2).[a2].Resize(UBound(arr) - 1, 6) = brr
- End Sub
复制代码 |
|