Alternative Pattern Match in search criteria

[Lachlan Williams]

Is it possible to alter the search criteria with patterns as substitutions (like when you case change or replace text in actions). Specific example, I have a .txt lookup table containing a list of property names in one column:
eg: 12 Smith St, 55 Main St, 10 Johnston Av

I want to search for a modified string version of those property names in the filename without having to add another column in the lookup table:
eg: 12_SMITH_ST, 55_MAIN_ST, 10_JOHNSTON_AV

So, the search criteria pattern would be change to UPPERCASE and replace " " with "_"

Historically, I've found that changing columns in that lookup table breaks EVERY Hazel rule that uses it (a LOT of rules), but also, I can see that a dynamic "text substitution" in search criteria could be useful. Any way to do this?

[Mr_Noodle]

You can't do that but you may want to consider using (anything) instead of a space to match both cases.