[問題] VBA的regex

[gecer (gecer)]

語言 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://www.ptt.cc/bbs/RegExp/M.1404521632.A.DE0.html
推 LPH66:((uA)|(mV)) 這樣試試?
推 lin1987www:你累了 Q_Q 仔細看其實是你看錯了! Match的數量都是1
→ lin1987www:第一張圖是你看Match(m)的數量，第二張圖是你Pattern
→ lin1987www:Match的數量