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.

  1. Open database.txt.
  2. In the Filter toolbar, open Advanced Filter.
  3. Drag-and-drop search strings.txt from File Explorer to the Find list on the left panel.
  4. Click Filter.
    Advanced Filter
  5. To save the filtered lines, in the Filter toolbar, click Extract All | Extract Matched Strings.
    Extract All