Match Numbers in File

This filter compares ticket numbers with numbers in a selected text file. The filter accepts a ticket if it contains selected count of numbers from that file.

To use the filter, first click Select button to browse for the text file with numbers to be compared with filtered tickets. Then tick the desired count(s) of matching numbers in the table below.

The file with matching numbers must follow these formatting rules:

• Each set of numbers is on a separate line of text.
• Numbers on each line are separated with space character(s) or TAB character(s) or colon (:) or semicolon (;) or comma (,) or dash (-) character. For example:
  • 1 2 3 4
  • 1:2:3:4
  • 1;2;3;4
  • 1,2,3,4
  • 1-2-3-4 
• Lines starting with hash (#) character are ignored.
• The number of lines in the file is not limited.
• The count of numbers on a single line is not limited.

Example

Let's assume we want to compare filtered tickets with the following file:

01,02,03,04
01,02,03,05
01,02,03,20
20,21,22,30,31
40,41,42,43

• When filter settings are Match 3 then:
• 01-02-03-04-05-06 - filter accepts this ticket because it matches in three numbers with the third line in the file.
• 41-42-43-47-48-49 - filter accepts this ticket because it contains three numbers from the last line in the file.
• 20-21-22-30-32-33 - filter rejects this ticket because it contains four numbers from the fourth line in the file and doesn't have three numbers from any other line in the file.
• 01-02-03-20-21-22 - filter accepts this ticket because it matches in three numbers with the fourth line in the file.
• When filter settings are Match 5, Match 4 then:
• 01-02-03-04-05-06 - filter accepts this ticket because it contains four numbers from the first line in the file.
• 01-20-21-22-30-31 - filter accepts this ticket because it contains five numbers from the fourth line in the file.
• 40-41-42-44-45-46 - filter rejects this ticket because it contains only three numbers from the last line in the file.
• When filter settings are Match 3, Max 1 then:
• 20-21-22-40-44-45 - filter accepts this ticket because it contains three numbers from the fourth line in the file and doesn't match any other line in three numbers.
• 01-02-03-44-45-46 - filter rejects this ticket because it contains three numbers from the first three lines in the file and the filter condition limits that maximum count of matching lines to one only.
• 01-02-03-04-05-06 - filter accepts this ticket because it matches in three numbers with the third line in the file.
• When filter settings are Match 0, Min 3 then:
• 04-05-06-07-08-09 - filter accepts this ticket because there are at least three lines in the file that don't match this ticket in any number (first, second, fourth and fifth).
• 01-02-03-04-05-06 - filter rejects this ticket because there are only two lines in the file that don't match this ticket in any number (fourth and fifth).