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.txt
from 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.