Forum Discussion
Text filter from another table
I have a very large table with street addresses, some of which start with variations of PO Box (i.e. P.O Box, PO. Box, P.O. BOX, etc.). I have another table that has (I think) all the variations in i...
barritown
Solution Sage
Solution SageHi,
If performance is not critical here, I can propose a brute force solution - you can try to CROSSJOIN your tables and then apply filtering.
Like that:
If performance matters, you may need a more elegant solution.
***Update***
Since you need the opposite - to find the rows that DON'T follow any of the filter patterns, the solution would be:
Okay I'll give that a try, thanks