作者gecer (gecer)
看板RegExp
标题[问题] VBA的regex
时间Sat Jul 5 08:53:49 2014
语言 VBA excel 2007 windows XP
code as follow
********************************************************************
Dim myRegExp As Object
Set myRegExp = New RegExp
myRegExp.IgnoreCase = True
myRegExp.Global = True
myRegExp.Pattern = "^(\d+\s+[0-7]\s+\d+(uA|mV))"
Dim s As String: s = "6532 0 70mV "
Dim m As Object
Set m = myRegExp.Execute(s)
**********************************************************************
I want to match "6532 0 70mV" or "6532 0 70uA"
but when s is "6532 0 70uA" the m contains only one item,which is
"6532 0 70uA"
http://i.imgur.com/PFQNfZ9.png ,but when
s="6532 0 70mV" it contains 2 items "6532 0 70mV" and "mV"
http://i.imgur.com/Pg2gqNu.png,
I don't know why the later case contains 2
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 111.255.1.224
※ 文章网址: http://webptt.com/cn.aspx?n=bbs/RegExp/M.1404521632.A.DE0.html
1F：推 LPH66:((uA)|(mV)) 这样试试? 07/05 19:54
2F：推 lin1987www:你累了 Q_Q 仔细看其实是你看错了! Match的数量都是1 07/07 09:22
3F：→ lin1987www:第一张图是你看Match(m)的数量，第二张图是你Pattern 07/07 09:22
4F：→ lin1987www:Match的数量 07/07 09:23