Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: Regex on excel

by AnomalousMonk (Bishop)
on Aug 06, 2020 at 17:24 UTC ( #11120434=note: print w/replies, xml ) Need Help??

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:  <%-{-{-{-<

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11120434]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2020-10-30 20:18 GMT
Find Nodes?
    Voting Booth?
    My favourite web site is:

    Results (284 votes). Check out past polls.