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

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11120434]
help
Chatterbox?
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
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (284 votes). Check out past polls.

    Notices?