Filtering and columns
Use regex in a filter
Any text field can be matched by pattern rather than by a fixed string, and a single filter can hold more than one pattern. That is often tidier than adding several filters that all target the same field.
Set the operator to pattern matching
On a text or link field, choose the pattern option instead of contains.
Enter your pattern
Write the expression you want to match against that field.
Add further patterns to the same filter
Add another term and give it its own connector. A term joined with or widens the match, and a term joined with not excludes it, so one filter can express "matches this or that, but not the other".
Worth knowing
- Lookahead is not supported, and that is a deliberate trade rather than a gap. The engine runs in linear time, so no pattern you can write will hang your search or stall the grid.
Next
Combine filters with and, or and notExpress requirements, alternatives and exclusions in one filter setBuild your first filterNarrow eight million shops down to the ones worth contactingDescribe a search in your own wordsType what you are looking for and get a real filter set you can check before applying
Try this on the real database
Free trial with the full dataset and every filter, and the allowance resets daily rather than expiring.