mercredi 25 février 2015

Find 2 or more occurences of a pattern "submit report" or "submitted report" using vba regex

I am new to vba regex and I need to find the fields in a very large report where the text in a text field or text cell contains 3 or more occurrences of the following pattern:


"submit report" or "submitted report" or "submitting rep" or "resubmitted rep" or "resubmitting report" using vba regex, case insensitive.


I have not been able to figure out the regex and the condition count so it could be adjusted to 2, 3 or more.


Any guidance will be greatly appreciated.


Aucun commentaire:

Enregistrer un commentaire