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
- In the Filter toolbar, open Advanced Filter.
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.