How do I filter a file based on millions of search strings?
Let’s say we have a file that we want to filter called database.txt and a list of strings that we want to filter with, separated by newline, called search strings.txt.
- Open
database.txt. - In the Filter toolbar, open Advanced Filter.
- Drag-and-drop
search strings.txtfrom File Explorer to the Find list on the left panel. - Click Filter.

- To save the filtered lines, in the Filter toolbar, click Extract All | Extract Matched Strings.


