| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bill Derrick | Catskill Bears | 58 | 73 | 61 | 75 | 66 | 86 | 49 | CAN | 77 | 1 | 90,000$ |
| Bruce Latreille | Worcester Plainsmen | 60 | 86 | 76 | 88 | 58 | 93 | 62 | CAN | 36 | 2 | 45,000$ |
| Denny Haworth | Orono Mohawks | 62 | 66 | 93 | 55 | 82 | 99 | 43 | CAN | 51 | 1 | 65,000$ |
| Don Ugolini | Syracuse Bulls | 71 | 74 | 84 | 78 | 66 | 76 | 54 | USA | 61 | 3 | 75,000$ |
| Ed Mundy | Boston Eagles | 99 | 71 | 95 | 75 | 94 | 99 | 46 | USA | 50 | 1 | 225,000$ |
| George Wegrzynowicz | Kingston Kings | 76 | 73 | 78 | 73 | 84 | 94 | 31 | CAN | 63 | 1 | 250,000$ |
| Gerry McTernan | Burlington Cougars | 75 | 78 | 81 | 96 | 84 | 99 | 46 | USA | 57 | 2 | 100,000$ |
| Jack Gravel | Albany Indians | 65 | 70 | 84 | 81 | 99 | 95 | 45 | USA | 61 | 2 | 76,000$ |
| Jim Doyle | Adirondack Mountaineers | 72 | 79 | 66 | 97 | 63 | 73 | 67 | USA | 35 | 2 | 75,000$ |
| Jim Govatsos | Providence Englishmen | 99 | 86 | 71 | 99 | 99 | 99 | 36 | USA | 73 | 2 | 70,000$ |
| John Jacob | Buffalo Wings | 71 | 73 | 84 | 91 | 99 | 92 | 33 | CAN | 57 | 1 | 50,000$ |
| John Jacobs | Binghamton Roadrunners | 71 | 69 | 70 | 90 | 94 | 84 | 26 | USA | 67 | 3 | 75,000$ |
| John Ranalli | Hartford Red Devils | 91 | 93 | 92 | 72 | 96 | 99 | 54 | CAN | 52 | 2 | 60,000$ |
| Mike Fox | New Haven Hawks | 92 | 82 | 83 | 72 | 79 | 99 | 41 | CAN | 70 | 5 | 240,000$ |
| Pete Maybury | Durham Panthers | 82 | 78 | 62 | 74 | 85 | 90 | 40 | CAN | 59 | 3 | 72,500$ |
| Rob MacDonald | Rochester Lakers | 61 | 99 | 81 | 72 | 76 | 86 | 64 | CAN | 65 | 2 | 70,000$ |
| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alan McPhee | Hamilton Roadrunners | 85 | 67 | 66 | 72 | 75 | 75 | 60 | USA | 38 | 2 | 45,000$ |
| Bill Colanigione | Buffalo Jr. Wings | 82 | 72 | 75 | 92 | 74 | 94 | 71 | USA | 32 | 1 | 42,500$ |
| Bob Blanchard | Skaneatles Bulls | 72 | 75 | 89 | 70 | 61 | 76 | 64 | USA | 35 | 1 | 60,000$ |
| Bob Braun | Waterbury Red Devils | 60 | 85 | 60 | 80 | 80 | 70 | 65 | USA | 38 | 3 | 50,000$ |
| Brad Selwood | Lake Placid Mountaineers | 63 | 72 | 81 | 99 | 62 | 87 | 53 | CAN | 33 | 2 | 45,000$ |
| Brian Teeple | Bridgeport Hawks | 80 | 84 | 76 | 99 | 99 | 98 | 22 | CAN | 57 | 1 | 250,000$ |
| Ernie Langevin | Ulster Bearcats | 80 | 74 | 63 | 81 | 60 | 85 | 70 | USA | 37 | 1 | 47,500$ |
| Fred Cairns | Holyoke Plainsmen | 43 | 65 | 76 | 67 | 76 | 81 | 59 | CAN | 57 | 3 | 52,500$ |
| Gene Preece | Montpelier Cougars | 71 | 86 | 71 | 70 | 73 | 73 | 57 | CAN | 49 | 1 | 45,000$ |
| Ken Daghlian | Portsmouth Panthers | 72 | 73 | 57 | 91 | 63 | 83 | 67 | USA | 34 | 3 | 43,500$ |
| Kevin Laine | Newport Reds | 71 | 66 | 80 | 76 | 79 | 84 | 56 | USA | 34 | 1 | 50,000$ |
| Mike Mullalley | Canadaigua Lakers | 85 | 68 | 73 | 69 | 59 | 89 | 51 | CAN | 64 | 1 | 40,000$ |
| Pete Gerster | Troy Indians | 86 | 77 | 53 | 60 | 98 | 88 | 32 | USA | 56 | 1 | 60,000$ |
| Ron Ivany | Bangor Mohawks | 72 | 72 | 59 | 61 | 79 | 79 | 46 | CAN | 51 | 1 | 50,000$ |
| Tim Roth | Boston Jr. Eagles | 90 | 70 | 80 | 50 | 60 | 80 | 60 | CAN | 38 | 3 | 45,000$ |
| Willard Stephens | Newburgh Kings | 87 | 79 | 73 | 89 | 73 | 93 | 77 | USA | 37 | 2 | 45,000$ |
| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Coaches Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bill Grant | 71 | 77 | 65 | 75 | 71 | 96 | 54 | CAN | 69 | 0 | 225,000$ |
| Mike Barger | 79 | 57 | 85 | 72 | 63 | 83 | 57 | CAN | 76 | 0 | 74,000$ |
| Nick Lasch | 79 | 71 | 70 | 75 | 72 | 92 | 38 | USA | 78 | 2 | 57,500$ |
| Vic Breadner | 94 | 85 | 68 | 51 | 70 | 99 | 45 | USA | 75 | 0 | 55,000$ |
| Vic LeMire | 49 | 68 | 71 | 64 | 94 | 99 | 46 | USA | 57 | 0 | 72,500$ |