SFRandy
03-26-2021, 02:24 PM
I have a string (filename, actually), that I want to see how many instances there are of XNNNN and/or XNNNNN, where N is a numerical digit.
For example, if filename is "N1234 and N22522 - Content", then I would like to know that there are 2 matches and be able to analyze the 2 matches.
I have it working for a single match, as follows:
Dim nNumberPattern As String
nNumberPattern = "(N[0-9]{3,}).*Content(s?).*"
Dim nNumberMatches
Dim nNumber As String
With nNumberRegEx
.Global = True
.Pattern = nNumberPattern
End With
' Let's find the n-number that we are working with (using the file's name)
If nNumberRegEx.Test(myWorksheetObj.Parent.Name) Then
Set nNumberMatches = nNumberRegEx.Execute(myWorksheetObj.Parent.Name)
nNumber = nNumberMatches(0).SubMatches(0)
How can I adapt this to identify that there are 2 matches when filename is "N1234 and N22522 - Content" and then be able to read/access/use each of "N1234" and "N22522"?
For example, if filename is "N1234 and N22522 - Content", then I would like to know that there are 2 matches and be able to analyze the 2 matches.
I have it working for a single match, as follows:
Dim nNumberPattern As String
nNumberPattern = "(N[0-9]{3,}).*Content(s?).*"
Dim nNumberMatches
Dim nNumber As String
With nNumberRegEx
.Global = True
.Pattern = nNumberPattern
End With
' Let's find the n-number that we are working with (using the file's name)
If nNumberRegEx.Test(myWorksheetObj.Parent.Name) Then
Set nNumberMatches = nNumberRegEx.Execute(myWorksheetObj.Parent.Name)
nNumber = nNumberMatches(0).SubMatches(0)
How can I adapt this to identify that there are 2 matches when filename is "N1234 and N22522 - Content" and then be able to read/access/use each of "N1234" and "N22522"?