tablesorter

Metric parser

Flexible client-side table sorting

NOTE!

• In v2.22.2,
  • Added header data-attribute data-metric-name-full which will contain the full base unit name, e.g. "byte|Byte|BYTE". This change should allow for different capitalizations of the base unit name.
  • Added header data-attribute data-metric-name-abbr which will contain the abbreviated base unit name, e.g. "b|B". This change also should allow for different capitalizations of the base unit name.
  • Each name is separated by a pipe, or vertical bar, ("|") without spaces, because it will eventually be used in a regular expression - the vertical bar signifies an "OR" operator.
  • When using these new data-attributes, the value in data-metric-name (now deprecated) will be ignored; eventually data-metric-name support will be removed.
  • These additions were made because of common misuse of abbreviated capitalization in the metric units, i.e. "kB" versus "kb". The lower case "b" is for "bit", and upper case "B" is for "byte". I am guilty of this too!
• This parser will convert numbers with metric prefixes ("Mega", "Giga", etc) into appropriate values so they are sorted correctly.
• The base name must be included in the header:
  • The base is the unit of measure, such as "byte", "meter", "liter", etc.
  • deprecated When saving the base, include both the abbreviation and full name of the base separated by a vertical bar (shift-\) b|byte.
  • deprecated Store this information within the header's data-attribute (data-metric-name="b|byte") - this data-attribute should be considered deprecated as of v2.22.2, use data-metric-name-full & data-metric-name-abbr instead.
  • If no base information is found, it will default to m|meter.
• Because metric prefixes can be applied to binary values, the parser will calculate the cached value based on the binary multiple, i.e. "1 kB" is actually "1024 bytes". See this article for more details.
• This parser does not (yet) support the IEC recommendations for binary prefixes (i.e. "kibibyte (KiB)", "mebibyte (MiB)", etc).
• Supported prefixes include: Yotta (10²⁴), Zetta (10²¹), Exa (10¹⁸), Peta (10¹⁵), Tera (10¹²), Giga (10⁹), Mega (10⁶), kilo (10³), hecto (10²), deka (10¹), deci (10^-1), centi (10^-2), milli (10^-3), micro (10^-6), nano (10^-9), pico (10^-12), femto (10^-15), atto (10^-18), zepto (10^-21) and yocto (10^-24).
• This demo includes the stored metric values within the table cells, toggle the view using the button below.

Demo

Page Header

<!-- blue theme stylesheet with additional css styles added in v2.0.17 -->
<link rel="stylesheet" href="../css/theme.blue.css">
<!-- tablesorter plugin -->
<script src="../js/jquery.tablesorter.js"></script>

<!-- load metric parser -->
<script src="../js/parsers/parser-metric.js"></script>

Javascript

$(function() {

  $("table").tablesorter({
    theme : 'blue',
    widgets : ["zebra"]
  });

});

HTML

<table class="tablesorter">
  <thead>
    <tr>
      <th class="sorter-metric" data-metric-name-full="byte|Byte|BYTE" data-metric-name-abbr="b|B">Metric (binary) Size</th>
      <!-- "data-metric-name" is deprecated in v2.22.2, use "data-metric-name-full" and "data-metric-name-abbr" instead -->
      <th class="sorter-metric" data-metric-name="m|meter">Metric Length</th>
    </tr>
  </thead>
  <tbody>
    <tr><td>1 byte</td><td>1 nm</td></tr>
    <tr><td>1 kB</td><td>1 kilometer</td></tr>
    <tr><td>1 Gigabyte</td><td>1 Gm</td></tr>
    <tr><td>10 MB</td><td>1 Tm</td></tr>
    <tr><td>1 MB</td><td>1,000 mm</td></tr>
    <tr><td>1 TB</td><td>1 meter</td></tr>
    <tr><td>1 Petabyte</td><td>1 hm</td></tr>
    <tr><td>1 ZB</td><td>1 dam</td></tr>
    <tr><td>1 ZettaB</td><td>1 millimeter</td></tr>
    <tr><td>1,025 MB</td><td>1 Mm</td></tr>
    <tr><td>1,000 kilobytes</td><td>1 dm</td></tr>
    <tr><td>1 EB</td><td>1 µm</td></tr>
    <tr><td>1023 MB</td><td>1 pm</td></tr>
  </tbody>
</table>