Building and recognising specific regex patterns

12 views
Skip to first unread message

stainless

unread,
Mar 4, 2017, 6:51:43 AM3/4/17
to excel vba
I need to recognise patterns in text starting with a specific variable text value and ending in 0-3 numeric values.

For example:

I have several strings of text that I am searching for at the start of a text string:

         S
         FDC
         PP
         Doctor

So I will want to loop through these (already in an array) and test whether a text string starts with these values and ends with 0-2 numeric digits:

i.e.    Text string "S01" is true
                           "PQ" is false
                           "FDC99" is true
                           "Doctor" is true
                           "Dr01" is false

I have not worked much with Regex before so am struggling to workout how I recognise the pattern for each of the strings. Any ideas?

If I do find ,matches, I will then replace the text part with a different string

i.e. "S" is replaced by "Stamps "
      "FDC" is replaced by "First Day Covers "
      "PP" is replaced by "Presentation Packs "
      "Doctor" is replaced by "Doctor Who "

The replacement texts are in the same array BinderNames(1 To BinderCount, 1 To 2)   so the first and 2nd entries in each row are the search text and the replacement text.

Is there a simple way of using Regex to do this? 
Reply all
Reply to author
Forward
0 new messages