CharityBags

Notes on using 'Table Filter', filtering and sorting . . .

You can look at the table below just as it is - browsing up and down the page as usual  
And you can search it as usual - for instance using Ctrl-F (then using the Enter or F3 keys).

However, this table uses table-filter software - so you can filter and/or sort entries.

Filtering:  At any stage, you can select (in other words, filter) the entries below.
This "collapses" the table temporarily - so it only lists the items (rows) which you want.
Do this as follows:

The heading(s) of the selected column(s) and the selected text are highlighted.
The filter isn't case-sensitive - so UPPER or lower case makes no difference.
Use two vertical-line characters (by the "Z" key) to indicate "or".  Example:  bloggs||smith
Other codes include:  {x =begins with x    }x =ends with x    !x =not x    [empty] =empty 
See http://tablefilter.free.fr/   for more of these codes (with examples).
At the top of the table, there's a counter that tells you the number of rows shown.

Also, you can search using Regular Expressions (=regex)   with this new version (v2.4).
Do this by putting "rgx:" at the start ("rgx" followed by a colon ":").
Example: "rgx:200[3-8]"  - this finds all items with years between 2003 and 2008

  Sorting:

These filtering and sorting facilities allow you to interact with the table - so you can change it to suit your needs.  They make the table behave like a simple database or spreadsheet.

See our Web design page for more on table filtering facilities (JavaScript).
The software used on the table below is called "HTML Table Filter" (by Max Guglielmi).
For more help on using it (eg search syntax), see http://tablefilter.free.fr/  

    

Browsers:  The software works fine with Internet Explorer 8, Firefox and Safari.  It's fine with Opera too - except it only sorts one column at a time.

By the way, there's another nice JavaScript table utility called "TableTools"   (by Mingyi Liu).  A modified version is available as a free add-on for the Firefox browser.  When you're browsing with Firefox and see any table, you can call up the TableTools utility (with a right-click) and do powerful filtering and sorting (and more).