|
发表于 2015-1-15 22:35
|
显示全部楼层
本楼为最佳答案
- Sub 拆分() '执行多个正则表达式
- Set regx = CreateObject("vbscript.regexp")
- rw = Cells(Rows.Count, "r").End(3).Row
- With regx
- .Global = True
- For Each ar In Array("\S+(?=镇)|\S+办事处", "\S{2}(?=村)|\S{2}居委会", "\d{1,2}|((\D{1,2})(?=组))") '将多个正则表达式写在一个数组中
- n = n + 1
- .Pattern = ar '循环正则表达式
- For Each Rng In Range("r4:r" & rw)
- Set mat = .Execute(Rng)
- For Each m In mat
- y = y + 1
- Cells(Rng.Row, y + n + 3) = m
- Next
- y = 0
- Next
- Next
- End With
- End Sub
复制代码
补偿名册123.rar
(14.84 KB, 下载次数: 6)
|
|