Notes
- This parser (added v2.17.3) will convert roman numerals into their decimal equivalent so the table column can be sorted correctly.
- There are actually 3 separate parsers included with this script.
- They are very similar, but were written to cover different use cases.
- Refer to each in their separate sections below.
- This demo includes the stored roman numeral values within the table cells, toggle the view using the button directly above the table.
"roman" parser
- This parser is optimized for columns that contain only roman numerals.
- In the demo below, this parser is used for the "Short" and "Long" columns.
- This parser has no option settings.
$(function() { $("table").tablesorter({ theme: 'blue', widgets: ['zebra'], headers: { 0 : { sorter: 'roman' }, 1 : { sorter: 'roman' } } }); });
"roman-ignore" parser
This parser is designed to use the
The value obtained from the
In this example (see the "Ignore regex" column in the demo below), content at the beginning of the cell is set to be ignored. This should leave the roman numeral string to be parsed by this script (spaces are trimmed automatically).
roman_ignore
option to either:
Ignore The Last "X" Characters
For content that contains a roman number followed by an alphabetical character, such as "Ia" or "IIb", this parser can be set to ignore the last character (spaces are trimmed automatically):$(function() { $("table").tablesorter({ theme: 'blue', widgets: ['zebra'], headers: { 2 : { sorter: 'roman-ignore' } }, // roman numeral parser option // ignore the last (1) character(s) in column 2 (zero-based index) // the two zeros in the array are just placeholders ( [ , , 1 ] works as well ) roman_ignore: [ 0, 0, 1 ] }); });
Remove Non-Roman Numerals
For cells that contain a bit more complex layout, you can define a regular expression to ignore (remove) certain parts of the content.The value obtained from the
roman_ignore
option array is used within a javascript replace function, so it can be either a regular expression or a string.In this example (see the "Ignore regex" column in the demo below), content at the beginning of the cell is set to be ignored. This should leave the roman numeral string to be parsed by this script (spaces are trimmed automatically).
$(function() { $("table").tablesorter({ theme: 'blue', widgets: ['zebra'], headers: { 3 : { sorter: 'roman-ignore' } }, // roman numeral parser option // ignore any words at the beginning of column 3 (zero-based index) using a regular expression // additionally, if all column content contains the same character to ignore, a string can be // passed within this option, e.g. "Chapter " // the three zeros in the array are just placeholders ( [ , , , /^(\w+\s)/ ] works as well ) roman_ignore: [ 0, 0, 0, /^(\w+\s)/ ] }); });
"roman-extract" parser
- This parser will attempt to extract out a roman numeral block from the cell content.
- It's not perfect. If the content contains two blocks of roman numerals, they will be combined. For example,
- If a cell contains
X plus VII
, the parser will extract outXVII
and return a value of 17. - Or worse yet, if a cell contains
VI minus X
, the parser will extract outVIX
which is not a valid roman numeral, so it will instead return the initial value ofVI minus X
. If this is the case, use the "roman-ignore" parser instead.
- If a cell contains
$(function() { $("table").tablesorter({ theme: 'blue', widgets: ['zebra'], headers: { 4 : { sorter: 'roman-extract' } } }); });
Demo
parsed values within the columnPure Roman Numerals | Ignore Non-Roman Numerals | Extract Roman Numerals | ||
---|---|---|---|---|
Short | Long | Ignore last (1) character * | Ignore regex (/^(\w+\s)/) | Extract |
I | MDLXXXV | iiia | Mark I | 2000 XXVII Sydney |
MXI | MDCLXVI | iiib | Mark IV | 2012 XXX London |
XII | MMDCCCLVIII | ia | Mark V | 2020 XXXII Tokyo |
CXI | MMCCI | va | Mark VII | 2004 XXVIII Athens |
XXI | MDCCCXL | vi b | Mk III | 1980 XXII Moscow |
XIII | MMMCXXIX | iva | Mod X | 1972 XX Munich |
V | DLXXVII | via | Mod IV | 2016 XXXI Rio de Janeiro |
X | MDCLXV | xia | Mk VIII | 1996 XXVI Atlanta |
XI | MDXVIII | xiiz | Mod XII | 1976 XXI Montreal |
CLXI | MDCCCLX | xd | Mk 0 | 1992 XXV Barcelona |
C | CCCXCI | iiic | Mk VI | 1988 XXIV Seoul |
LV | MLXXX | xxf | Mk II | 1984 XXIII Los Angeles |
IX | DCCLVII | lig | Mod L | 2008 XXIX Beijing |
roman_ignore
option array; notice that "vi b" sorts before "via" - spaces do matter!)
Page Header
<!-- blue theme stylesheet with additional css styles added in v2.0.17 --> <link rel="stylesheet" href="../css/theme.blue.css"> <!-- tablesorter plugin; requires jQuery --> <script src="../js/jquery.tablesorter.js"></script> <!-- load roman numeral parser --> <script src="../js/parsers/parser-roman.js"></script>