Re: Help with a regex pattern please
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Fri, 21 Mar 2008 20:14:05 -0400
On Thu, 20 Mar 2008 16:55:57 -0700 (PDT), be_675@xxxxxxxxxxx wrote:
I have three individual sPattern's that I am working on. How can I
merge them together so that the pattern will look for three digits
followed by either a period, or by a space and a period, or by a space
and a letter?
Thanks
Const sPattern As String = "d{1,3}(?=\.)"
Const sPattern As String = "d{1,3}[\ ][\.]"
Const sPattern As String = "d{1,3}[\ ][?=\A-Z,a-z]"
Set oRegex = New RegExp
oRegex.Pattern = sPattern
oRegex.Global = True
If oRegex.Test(strIn) = True Then
Set colMatches = oRegex.Execute(strIn)
strData = colMatches(0)
End If
Your examples do not match your description in several aspects:
Your description says you are looking for **three** digits;
Assuming the "\" should be before the "d", your examples will match 1, 2 or 3
digits.
In your first example, you are using a positive lookahead assertion which means
you will only match the digits, and not the subsequent period.
In your second example, you don't use the positive lookahead assertion, so the
subsequent <space dot> will be matched also. This seems inconsistent. And
also, enclosing the <space> and the <.> within a character class is
unnecessary.
Finally your third pattern, in the area following the digits, matches a
<space>, but the subsequent series within the character class do not make up a
legitimate pattern, because the backslash cannot be followed by an "A" when
within a character class. Also, note that you have a <comma> within the
character class, so you would be also matching a <comma>, which is not
something you stated in your description
Going by your description, if you want to match a series of three digits,
followed by one of those three sequences you describe, then:
"\d{3}(\.|\s\.|\s[A-Za-z])"
or, if you want to match ONLY the digits, provided they are followed by one of
those other three sequences, then:
"\d{3}(?=\.|\s\.|\s[A-Za-z])"
--ron
.
- References:
- Help with a regex pattern please
- From: be_675
- Help with a regex pattern please
- Prev by Date: Previously Functioning Date Interpreter Now Failing
- Next by Date: Re: Possible to pass a variable to Excel from command line/short cut?
- Previous by thread: Re: Help with a regex pattern please
- Next by thread: Auto-Insert
- Index(es):
Relevant Pages
|
|
