Toggle Help to get more info
- This page contains unusual sorting datatypes, like mixed US-styled timestamps, European-styled ones, and even unorthodox (year-first) ones.
- It also demonstrates that you can sort a column arbitrarily (move your mouse over to each table cell of the "arbitrary ranking" column to see the real value used in sorting)
- It demos supplying a custom sort function to sort filename styled (abc123) data so that a13 will come behind a2 instead of the other way around when the data are sorted as string ("abc123" column)
- Thru custom sort function, you can even convert different data units (bits, bytes, KBs, MBs...) into uniform one before sorting to ensure correct sorting (see "diff. units" column)!
- You can even combined arbitrary sorting with custom datatype sorting (mouseover on "abc123+rank" column to see the real data being sorted)!
- You can also write custom summary functions! Click "toggle summary" on Actions menu and check out the summary on the "diff. units" column (the Sum is custom function while min/max were built-in TableTools functions)
- Once you provide custom sort function, the range operator would automatically work on the custom datatypes (try "< 5 KBs & > 4 bytes" on the "diff. units" column and see!)
- Custom datatype sorting/summarize provides a powerful way to extend TableTools' already large number of supported datatypes/summary functions. But you do need to understand Javascript a bit before using it. In fact, it's the only feature that needs you to have any programming knowledge before enjoying the full power of TableTools! (right click and show page source to see how it's done!)
- One last thing this page shows is that filters/summaries can be loaded right after page loads
| US time |
European date (D/M/Y) & time |
Y-M-D date & time |
Arbitrary ranking |
abc123 |
diff. units |
abc123 + rank |
| Wed, 10 Sep 2003 20:28:54 GMT | 28/05/89 02:53:47 AM | 1994-07-18 01:23:36 PM | 4 | a | 8 bits | 19 |
| Saturday, April 22, 1989 12:55:58 PM | 06/10/1956 | 2000-05-21 | 17 | | 7 bits | 8 |
| Fri, 05 Mar 1993 02:36:19 GMT | 15/05/61 10:41:38 PM | 1958-02-11 | 17 | d14 | 10 KBs | 15 |
| Sunday, February 06, 1955 3:00:17 AM | 11/04/60 | 1970-02-20 10:34:50 PM | 13 | b12 | 8 bits | |
| 07/24/1958 | 19/03/76 | 50-03-18 06:50:04 PM | 2 | c5 | 7 bits | 2 |
| 08/16/90 | 03/07/1994 11:47:08 AM | 1986-07-22 | | a11 | 1 bit | 4 |
| 23/04/99 10:40:29 PM | 1999-06-26 09:15:10 AM | 16 | b14 | 10 bytes | |
| 02/17/2003 | 13/04/1997 | | 12 | d11 | | 8 |
| 09/27/1971 | 26/06/2005 09:22:41 PM | 1970-06-11 | 4 | d7 | 5 KBs | 10 |
| Sunday, September 08, 2002 10:43:13 PM | 27/02/85 | 1969-09-19 | 16 | b16 | | 18 |
| 02/24/85 | | 84-11-07 02:45:31 PM | 20 | | 10 bits | 16 |
| Friday, December 09, 1966 12:37:32 AM | 26/05/85 10:10:23 AM | | 3 | b3 | 9 bytes | |
| Thu, 08 Mar 1956 11:26:33 GMT | | 78-07-21 | 14 | | 2 bytes | 5 |
| Wed, 01 Mar 1950 01:34:55 GMT | 07/05/1999 | 98-08-04 10:12:19 AM | 6 | | 4 KBs | |
| Fri, 18 Dec 1959 06:56:43 GMT | 11/04/85 00:38:35 PM | 04-03-18 | 14 | b6 | | 6 |
| 02/02/1991 | | 66-07-03 11:46:07 AM | | d7 | 7 KBs | 4 |
