in reply to Regex on excel

... list of regular expressions ... (Some 100+) ...

Another possible approach to the problem you've described (in very general terms!) is discussed in haukex's article Building Regex Alternations Dynamically. You could conceivably process 100K+ rows from your spreadsheet in a single pass. This technique should be able to handle a couple of hundred regexes of reasonable size, but the boundary conditions of each regex might cause problems. Depending on the precise definition of a "partial" versus an "entire" match, this distinction should also be fairly easily managable.

Please see also Short, Self-Contained, Correct Example and How to ask better questions using Test::More and sample data.


Give a man a fish:  <%-{-{-{-<