P
pochtara
When using Regular Expression search using VBA script in Excel to search Word
document, "-" character in the word document gets skiped (substituted with ""
empty character).
Here is the string in Word: <DE4.0><SWR4.4.l‑CE6:A>
Here is the snipet of VBA code used:
With Selector.Find
.text = "\<DE?*^13"
.Replacement.text = ""
.Forward = True
.Wrap = wdFindzz
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
End With
While Selector.Find.Execute
s = Selector.text
Wend
The search find the string in the Word and here is the resulting string in
the VBA: <DE4.0><SWR4.4.lCE6:A>
As you can see the "-" hyphen character is missing in the resulting string
and I can't understand why and how to fix it.
Can someone help me with this?
Thanks
Alex
document, "-" character in the word document gets skiped (substituted with ""
empty character).
Here is the string in Word: <DE4.0><SWR4.4.l‑CE6:A>
Here is the snipet of VBA code used:
With Selector.Find
.text = "\<DE?*^13"
.Replacement.text = ""
.Forward = True
.Wrap = wdFindzz
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
End With
While Selector.Find.Execute
s = Selector.text
Wend
The search find the string in the Word and here is the resulting string in
the VBA: <DE4.0><SWR4.4.lCE6:A>
As you can see the "-" hyphen character is missing in the resulting string
and I can't understand why and how to fix it.
Can someone help me with this?
Thanks
Alex