|
උදවු:Sorting
Using sortable tablesWhen browsing Wikipedia you may encounter tables that have been made sortable. A sortable table is identified by the arrows in one or more of its header cells. Clicking them will cause the table rows to sort based on the selected column, in ascending order first, and subsequently toggling between ascending and descending order. The actual sorting process will happen on your computer using client-side JavaScript. For this reason it is only possible to use this functionality if you have JavaScript enabled in your web browser. The sorting process is also dependent on your computer and the amount of data. Sorting a very large table on a slow computer may take quite long. උදාහරණThis is an example of a small sortable table.
Tables with complex headersTables with more complex headers than before now sort correctly. For example:
Tables with complex datarowsTables can have cells spanning multiple rows, භාවිතා කරන්න The number of rows must be indicated with each use of rowspan. Before any sorting can be done, the rowspan setup must be correct. An incorrect rowspan organisation breaks sorting option, leaving incorrect data. උදාහරණ නරඹන්න. When sorted all the rows are filled. Tables without rowspan are much easier to maintain by less experienced editors, and by editors who are stopping by only once to edit the table. Correct rowspan numbers, with sorting in working order:
Note that, after sorting, the rowspanning cells are cut into rows and their content is repeated (the year "2014" in the example). වැරදි ලෙස rowspan නම්බර් වගුවෙහි ආකෘතිය විනාශ කර දමයි , and causing mix-ups in rows and columns:
Online table editors and rowspanThere is an easy online wiki table editor here: It makes it easy to edit the text and links in individual cells of a table. It is especially easy when there are no rowspans in the body of a table. See the previous section. Without rowspans it is easier to change the underlying framework of a table, and move stuff around. Once the wikitext framework is simpler, the online table editor is simpler too, because you don't have to edit the wikitext as much in order to edit the table. In a narrow space: sorting buttons in a separate rowTo make a table more compact in narrow screens, the sorting buttons can be put in an extra header row below the header cells containing text. The sorting button always ends up in the lowest header cell. Add a line break
{| class="wikitable sortable"
|-
! rowspan="2" | නම
! colspan="2" | දත්ත තීරුව
! rowspan="2" | වෙනත් තීරූ
|-
! දත්ත
! වෙනත් කරුණු
|-
! <br>!! !! !!
|-
Secondary keyIf a column contains a value multiple times then sorting the column preserves the order of the rows within each subset that has the same value in that column (stable sorting). Thus sorting based on a primary, secondary, tertiary, etc. key can be done by sorting the least-significant key first, etc. For example, to sort the table below on the Text column, then the Numbers column, first click on the "Numbers" column heading (the secondary sort key), then the "Text" column heading (the primary sort key). Another way to sort a table using multiple sort keys is to hold down the shift key while clicking on the column headings for the subsequent sort keys. For example, to sort the table below on the Text column, then the Numbers column, first click on the "Text" column heading (the primary sort key), then hold down the shift key and click on the "Numbers" column heading (the secondary sort key).
Creating sortable tablesTables can be made sortable via client-side JavaScript by adding Simple exampleThis is the wikisource of the table shown in the first section and shows the typical way to enable table sorting: {| class="wikitable sortable"
|-
! නම
! කරුණු
! තවත් කරුණු
|-
| පූසන්
| 273
| 53
|-
| බල්ලන්
| 65
| 8,492
|-
| මීයන්
| 1,649
| 548
|}
The Initial sort order of rowsWhen users are first presented with a table, the rows will always appear in the same order as in the wikitext. If you want a table to appear sorted by a certain column, you must sort the wikitext itself in that order. This is usually done for the first column. Restrictions
Making a Column Unsortable tableIf you want a specific column not to be sortable, specify Wiki markup {|class="wikitable sortable"
!ඉලක්කම්!!නාමය!!දිනය!!ගණනය!!class="unsortable"|Unsortable
|-
|1||Z||02-02-2004||5.00||මේ
|-
|2||y||13-apr-2005||||තීරූ
|-
|3||X||17.aug.2006||6.50||වගුගත
|-
|4||w||01.Jan.2005||4.20||වෙලා
|-
|5||V||05/12/2006||7.15||දැක්කද?
|-
!එකතුව: 15!!!!!!Total: 29.55!!
|}
ඒක ඔබේ බ්රව්සරයේ පෙනෙන්නෙ කොහොමද
Configuring the sortingForcing a column to have a particular data typeThe The following (case-insensitive) values are valid for
For example:
Without Default data type of a columnIf you do not specify a
If more than one possible type matches, the first type in the above order is chosen. For example, "24-12-2007" matches as a date, so is not treated as a number. Formatting and markup tags are ignored when determining the matching type. The sort mode is determined by the table element that is currently in the first non-blank row below the header. In the case of different data types within one column (according to the criteria mentioned above) the sort mode may change after sorting, which can give a cycle of four or even more instead of two. This is confusing and gives undesired sorting orders, so that can better be avoided. However, it can be complicated to assess whether an element can ever be at the top after any sorting operations on the same and other columns, and this can also change after deleting a row, or adding a column. Therefore it is wise to make sure that every element matches the criterion for the required data type. Using a row template this can be done very conveniently. An alternative method of making sure the sort mode of each column is as desired, is creating a first row that determines the sort modes, but in such a way that this row is not displayed and is excluded from sorting, see below. Specifying a sort key for a cellSometimes the value of a cell is not correctly parsed or one wants to sort the row in a special way. (e.g. a cell containing 'John Doe' should actually be sorted as 'Doe' and not as 'John'). This can be easily achieved by setting the Wiki markup {|class="wikitable sortable"
!Name and Surname!!Height
|-
|data-sort-value="Smith, John"|John Smith||1.85
|-
|data-sort-value="Ray, Ian"|Ian Ray||1.89
|-
|data-sort-value="Bianchi, Zachary"|Zachary Bianchi||1.72
|-
!Average:||1.82
|}
This gives:
It is especially handy to sort military ranks in rank-seniority order. Wiki markup {|class="wikitable sortable"
!Name and Surname!!Rank
|-
|data-sort-value="Smith, John"|John Smith||data-sort-value="16"|[[Corporal|Cpl]]
|-
|data-sort-value="Ray, Ian"|Ian Ray||data-sort-value="8"|[[Captain (OF-2)|Capt]]
|-
|data-sort-value="Bianchi, Zachary"|Zachary Bianchi||data-sort-value="10"|[[2nd Lieutenant|2 Lt]]
|}
This gives:
See also mw:Help:Sorting#Specifying a sort key. Keeping some rows together
Example where this is the case for the rows about the Netherlands:
If you have rows that contain colspans, then this might become a bit difficult. You can also use the
Dealing with problemsNumerical sorting problems
Normally, text breaks numerical sorting whether the text is before or after the number. The {{N/A}} template in any cell in a numerical column breaks numerical sorting of that column. This problem with {{N/A}} can be fixed by putting Even when using A dash, of any kind, in a blank cell breaks numerical sorting of a column. A dash is only allowed in front of a number. Dashes are allowed anywhere in cells if A dash after a number breaks numerical sorting of a column. Therefore a range (30-40) breaks numerical sorting of a column. Click the sorting button in the first table to the right, and see that sorting does not work. One solution is to use 2 columns for a range. See and experiment with preview views of the table in 15 October 2011 global protests. Using two columns there allows one to sort by either the minimum estimated crowd sizes, or by the maximum estimated crowd sizes. Another option is to use one column and add A plus sign (+) in front of a number does not break numerical sorting of a column. A plus sign in an otherwise empty cell can break numerical sorting of a column if the first non-empty cell going down a column consists of just a plus sign. A plus sign after a number can break numerical sorting if the first non-empty cell going down a column consists of a number followed by a plus sign. See and experiment with preview views of the table in 15 October 2011 global protests. References after numbers currently break numerical sorting of a column. For example; compare these 2 versions of an article: [1] [2]. One has a reference in the "Wins" column and one does not. If "c." (circa, indicates "approximately") is often found in columns of numbers. It needs to be moved to a different column. Or if Leading zeroes are not necessary for numerical sorting of a column. If it seems that way, then that means the column is being sorted alphabetically. Check for cells with anything other than numbers, and correct those cells according to the above rules. Date sorting problemsThere is now a way to manually force a column to sort by date. This is done by adding Year onlySee List of countries by income equality. Year sorting of a column works as long as no text is the first thing in a cell in the column. The year must be first. Text is OK after a year in a cell. References after the year are OK. A dash, of any kind, in a blank cell breaks year sorting of a column. Dashes after the year are OK. Unlike for numerical sorting the {{N/A}} template in any cell in a year column does not break year sorting of that column. If there are problems with year sorting check for any cells in the column with text or a dash (of any kind) as the first thing in a cell. Remove that text or dash to return the column to correct year sorting. Year and monthDate sorting does not work for columns with only the year before the month (no day). Adding
Month and yearDate sorting does not work for columns with only the month before the year (no day). Adding
Day, month, and yearSorting works correctly in all cases below. Years before 100 break sorting. For example; year 99. If a number for a day is missing, sorting is broken.
Month, day, and yearSorting works correctly in all the tables below. Years before 100 break sorting. For example; year 99. If a number for a day is missing, sorting is broken.
Year, month, and daySorting only works correctly with
Day and monthThis uses the {{Dts}} template. See the wikitext ("edit source").
Years before year 100Non-date keys are the only option. For example; with
{| class="wikitable sortable"
|-
! data-sort-type="number" | Date
|-
| data-sort-value="1111205" | 5 Dec 111
|-
| data-sort-value="350107" | 7 Jan 35
|-
| data-sort-value="2071205" | 5 Dec 207
|-
| data-sort-value="-1111205" | 5 Dec 111 BC
|-
| data-sort-value="-350107" | 7 Jan 35 BC
|-
| data-sort-value="-2071205" | 5 Dec 207 BC
|}
Any format can be used for what is seen by readers:
Examples of datatype auto detectionThe script sees what the cells contains at the first data row. The sorting mode becomes numeric if the cell of the first data row contains number only (comma and full-stop used in number formatting are accepted as number). The sorting order will work properly even though other cells contains text after numbers (e.g. "200 approx"). Empty cell is treated as "zero" when sorting numerically. It is sorted ascendingly first, and then descendingly. However bear in mind that the cell of the first data row will change accordingly after sorting. If that cell no longer contains number only after sorting, the sorting mode will change. For example, if the cell of the first data row becomes "200 approx" after sorting, this will make the sorting mode alphabetic.
The example with "a" gives alphabetic sorting; that with "e" ditto, the data are not mistaken for numbers in scientific format.
The first example demonstrates that text is positioned at zero, and that e.g. e3 for 1000 is not allowed; use 1e3 instead. It also shows that "-" should be used, not "−". The second example shows that expressions are not sorted according to their evaluated value, but according to the first number. The third example shows that a percentage is accepted for numeric sorting mode, but ignored in the actual sorting, so if a column contains percentages, all numbers have to be written as a percentage. The fourth example shows again that "c. 12" sorts at 0, as opposed to 12 with some text after it, which sorts at 12. In case such an element arrives at the top of a column, it causes alphabetic sorting mode. Background colors in sortable headersA background color in a header may cause that column to lose its sorting button - see bug 31755. Example:
Use {|class="wikitable sortable"
|-
!style="background-color:navajowhite" | Name
!style="background-color:navajowhite" | [[Surname]]
!style="background-color:navajowhite" | [http://example.com Height]
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|- class="sortbottom"
|colspan="2" |Average: ||1.82
|}
Produces this sortable table:
Tips and tricksExcluding rows from sortingSometimes it is helpful to exclude the last row of a table from the sorting process. There are two methods to achieve this. Header as a footerYou want a repeat of the header at the bottom. You do this by using the ! (Exclamation mark) syntax for all cells in the last row of the table. This will be recognized as a footer and the row will not be part of the sorting. Wiki markup {|class="wikitable sortable"
!Name!!Surname!!Height
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|-
!Name!!Surname!!Height
|}
What it looks like in your browser
This applies to all rows at the end of the table that are consecutive and fully made up out of header cells. Plain footerThis can be achieved using Wiki markup {|class="wikitable sortable"
!Name!!Surname!!Height
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|- class="sortbottom"
|colspan="2" | Average:||1.82
|}
What it looks like in your browser
It is possible to keep multiple lines fixed at the bottom, as long as the lines are consecutive. Forcing proper sort type and positioning rows with a hidden sort keyOne way to ensure each row is sorted appropriately is to add identical hidden rows ( Since the numeric sorting recognizes scientific notation, the number 9e99 and its negative are good candidates for forced numeric sorting when dealing with tables that contain large numbers. On the other hand, characters are ranked "ASCIIbetically", which places the exclamation mark (!) as the first sortable character and the tilde key (~) as the last; as such those two characters are good candidates for alphabetical sorting. {|class="wikitable sortable"
!Name!!Surname!!Height
|-style="display:none;"
|!a||!a||-9e99
|-
|<span style="display:none;">!b</span>''(brief)''
|<span style="display:none;">!b</span>''(from records)''
|<span style="display:none;">-9998</span>
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|-
|<span style="display:none;">~y</span>''(brief)''
|<span style="display:none;">~y</span>''(from records)''
|<span style="display:none;">9998</span>
|-style="display:none;"
|~z||~z||9e99
|}
Sorting with a hidden keyYou can customize the sorting on a table by placing a value that is easily sorted before the content, and then hiding that value with HTML/CSS. To do this, enclose the value you wish to hide in
Javascript sorting sorts the text inside and outside the tags, without the tags themselves. A hidden key can be put at the start. Both in the case of alphabetic and that of numeric sorting the first parts determine the order. Both parts together are used to determine the sort mode, so for numeric sorting the whole should be a valid number. Alphabetic sorting with hidden keyThe key comes at the start and is separated from the displayed text in such a way that the latter does not affect the sorting order. For example, if there are no blank spaces in any key, then a blank space can be used for separation. If a single blank space is possible in a key, two If the text inside and outside the tags together is of a form that would cause a sorting mode other than alphabetic (if and when the element is at the top), a character can be appended at the end of the key to avoid this, again making sure it does not affect the sorting order by putting a space or two Instead of "display=none" another way is using a font color equal to the background, e.g. Numeric sorting with hidden keyIf one needs to use alphabetic sort mode for numbers, one can construct a hidden alphabetic key for this purpose. The simple way of achieving this is to use template {{nts}} or {{ntsh}}. It can also be done manually for all numbers between −1e100 and 1e100 in arbitrary precision as follows:
In the following the left column shows the code for alphabetic sorting, where cryptic followed by the regular notation. The second column contains the same (hence sorting the same), but with code hidden with CSS. The third column does not contain hidden parts and uses numeric sort mode. When sorting the first or second column "more than 1e9" is positioned suitably, while when sorting the third column it is positioned like 0. Moreover, if this cell would be at the top alphabetic sort mode would be used.
PaddingSometimes entries are padded on the left for alignment purposes. This can adversely affect how they are sorted. Non-breaking spacesThe effect of left-padding with non-breaking space codes
See also Talk:List of U.S. states and territories by population/Archive 1#Sortable Table. Padding with zerosExample:
Formatnum can be combined with padleft: Integer: {{formatnum:{{padleft:299792458|16|0}}}} gives:
Real: {{formatnum:{{padleft:{{#expr:((299792458.056 - .5) round 0)}}|16|0}}}}.{{padleft:{{#expr:(1000000*(299792458.056 - ((299792458.056 - .5) round 0))) round 0}}|6|0}} gives:
DatesThe simplest way to format sortable dates in a table is to use the {{dts}} template. In accordance with the manual of style, the template would be invoked using the following format:
Please see the documentation of the template {{dts}} for full details on how to use this. Issues
Date sorting works by formatting dates so they can be sorted numerically. For example:
or
...for 21 July 2001. The "display:none" style can be used to hide a sortable numeric date before the displayed date. {{dts}} does this automatically, and is recommended in most cases. You can use ජූලි 7, 2012 etc. to get sortable dates. Example:
For years BC,
Numeric sort for BC/AD yearsIn certain circumstances the following sort technique may be used to provide a simple intuitive numeric sort for BC/AD years which are often surrounded by qualifying text. The sort in the BC/AD column (the fourth column in the example) is forced to be numeric (just as the other columns are forced to be alphabetic) by the inclusion of the first two hidden rows. These rows contain extreme values which will mean that these rows will ALWAYS be sorted to the top and bottom of the table, regardless of which column is sorted. As the sort mechanism determines the sort type to be used by examining the first cell in the column to be sorted the hidden rows ensure that a purely numeric value is always found in the first or last cell. The mechanisms used here are explained in the current article at: #Forcing proper sort type and positioning rows with a hidden sort key and #Examples. With numeric sorting guaranteed all that is needed is to precede the BC/AD text with a positive or negative year number in a hidden sort key ( The tables in the article: List of cities by time of continuous habitation have been modified to used this sort. The following example is modified (maintaining some defects in the content which will need resolving in the original!) from one of those tables: {| class="wikitable sortable"
|-
! Name
! Historical region
! Location
! Continuously inhabited since
! class="unsortable" | Notes
<!-- force numeric sorting on the hidden values in col 4 with hidden extreme max and min rows -->
|-style="display:none;"
|!a||!a||!a||-9e99
|-style="display:none;"
|~z||~z||~z||9e99
|-
| [[Ife]] || || {{Hs|Nig}}[[Osun State]], [[Nigeria]] || {{Hs|-500 !}}c. 500 BC ||
|-
| [[Axum]] || [[Kingdom of Axum]] || [[Ethiopia]] || {{Hs|-400 !}}c. 400 BC || Ancient capital of the Kingdom of Axum
.
.
.
|-
| [[Mogadishu]] || || [[Somalia]] || {{Hs|900 !}}c. 900 || settled by Arab traders
|-
| [[Dar es Salaam]] || || [[Tanzania]] || {{Hs|1865 !}}1865 || Founded by the Sultan of [[Zanzibar]].
|}
Controlling sorting and displayText undesired for sorting but needed for display:
Text undesired for display but needed for sorting:
Combining the two, we can have displayed text independent of text used for sorting, by fully hiding the latter, and fully putting the former in a separate column (in date sorting mode and numeric sorting mode) or in the same column after the hidden text (in alphabetic sorting). Fully putting the displayed text in a separate column may look ugly if it is not done consistently for a whole column, but only for elements that require this (e.g. if most entries in a column are single numbers, but some are ranges). Static columnA static column, e.g. with row numbers, can be obtained with two side-by-side tables with for each row the same height set in both tables:
The style can be adjusted to make it appear as a single table. If for some row the height of that row is too small for the text in a cell on one of the sides, the browser increases it, and there is no longer a match. A static column can also be created by enclosing the sortable table with the templates {{static column begin}} and {{end}}. See the documentation of {{static column begin}} for details. Maintaining tables sorted by rankTables in rank order may become difficult to maintain as the list is updated. People keep adding more rows to the table, but fail to renumber all the ranks each time a new one is added, because it seems too laborious. One way to resort a table that has been updated is to copy the table (in wiki markup), remove the table code ("|-", etc.), replace the cell separation code ("||") with Tab characters using Notepad (included with Windows) or TextEdit (included with OS X) and paste the table data into Excel or Google Docs (free of charge). Type "1" and "2" in the first two rows of the rank column, select both cells and then fill out the rest by dragging down the little blue square on the lower-right corner of the second cell. Copy the table from the spreadsheet and paste it into a text editor. Finally, add back the wiki table code with the text editor. Initial alphabetical sort versus initial sort by rank orderIt is a good idea to keep lists and tables in some kind of initial non-random sort order. Numbered rank order can be difficult to maintain as the list is updated, and as the rankings change. For example; in a nation list, updating the info for a single nation may require changing the rank numbers of many nations. This discourages people from updating the list. If they do update the list, they may not bother to update the rank order. So the list becomes more and more incorrect over time. See lists of country data. See Category:Lists of countries by per capita values and Category:Lists of countries.
It can be even easier maintenance and updating in some cases if the list is initially in alphabetical order, especially if the sources and references are also in alphabetical order. Readers can be instructed to use the sort button to order a number column. Removing a rank column (1,2,3) from a tableYou can remove the rank column cells one-by-one manually, or with a quicker method. Unfortunately, none of the quick methods listed below can be done with the Notepad text editor that comes with Windows. The methods below are specific to NoteTab Light (freeware version of NoteTab). It installs quickly and easily. If the rank column (1,2,3) is the first column, then there is a fast way to remove it. First paste the wikitext for the table list into a new page in Notetab Light. Click your mouse cursor at the top left. Do not select anything. Click on the "modify" menu, then "block", and then "delete". Enter the block dimensions in the dialog box. For long lists you will need to break up the list first into a 1-digit (0-9) rank section, a 2-digit (10-99) rank section, and a 3-digit (100-999) rank section. To get the number of lines go to the tools menu, then "text statistics", then "more", and then scroll down to the bottom for the total number of paragraphs. Enter that number in the spot for "block rows" in the dialog box. Then click OK. The block with the rank column will be removed. Then put back |- (wikitext for row) between each line. Do that via find-and-replace by replacing ^p with ^p|-^p
If there are blank lines between the entries replace ^p^p with ^p|-^p Putting a table in alphabetical orderIf you also want to alphabetize the table, then first make sure the alphabetical column is the first column. To quickly alphabetize the list paste the wikitext into a new page in Notetab Light. Click on the "modify" menu, then "lines", then "sort", and then "ascending". That will put "A" at the top and "Z" at the bottom. Put back |-' (wikitext for row) between each line as described above. Copy the wikitext and paste it back into the article. Save the page. Auto-ranking or adding a row numbering column (1,2,3) next to a tableThere are Phabricator threads asking for a table option for a fixed column, a static rank-order column, or row numbering. See phab:T42618. It supercedes phab:T42634. A patch is being tested now. When the patch is implemented in Wikipedia it will be possible to use references, flag icons, and wide note columns in tables with autonumbering of rows. The rank column (1,2,3) can be removed, and put to the side of the table as a row numbering column. See examples farther down. See List of countries by incarceration rate. Its editing is explained in detail at Commons:Convert tables and charts to wiki code or image files (section about list of countries by incarceration rate). See also: List of countries by intentional homicide rate. Do not use flag icons with the country names. They mess up row alignment more and more as the text size used is smaller and smaller. The row number column never has to be updated, except to add more numbers at the end if necessary. For example; when adding more nations. This allows any initial sort order for the table. It allows any column to be sorted later via the sort button, and still see the same row numbering. In the examples below click the sort button above a column in the main table to the right of the row number column. Note that the row number column on the left does not change. It sorts independently. This allows one to see rank order for any column. A note can be added above the table; something like this: A separate row number column only works when there is only one line per row in the main table. So wide tables, or tables with a notes column are problematic. There could be 2 lines in some rows, depending on screen width, and the length of notes. Rows will wrap from being one line to two lines. Decrease your browser width to see. For example; see notes column here: List of countries and dependencies by area. Wide tables can be narrowed in some cases by using breaks in the header titles: <br>. Also, the sorting icons can be put in a separate header row. Tables with references within the table are problematic. Reference numbers are in superscript, and this may or may not increase the line height of the row. It usually does. It depends on the current state of the MediaWiki software, and whether it increases line height for rows with references. So a separate row number column may not work in this case, especially when multiple cells in a column have references. The more rows with references, the more the misalignment as one goes down the table. One solution is to point to a notes section below the table. See: List of countries by intentional homicide rate. The references are above the table, or in the notes section below the table. Example tablesHere is how to put a main table adjacent to a separate row number table.
The two tables are combined by wrapping them within a 3rd table that does not have a border. Look at the wikitext to understand. See examples below. It is not necessary to put text in the header cell above the number column. You can leave it blank, but sortable. Add
Align the multiple headers across the table below by adding
With wider tables the rows only line up between the table and the rank column if all the rows below the headers only use one line each. So it is a good idea to avoid tables that are too wide. For that reason avoid note columns, too. Narrow your browser window to see the problem with wider tables such as the one below. Another problem is that the rank column can drop down out of sight when the tables are viewed on a narrow screen, or when the browser width is narrowed. Adding
For the above table here is the wikitext at the top of the wrapping table, followed by the header wikitext for the rank column: {|
|- style="vertical-align:top;"
|
{| class="wikitable sortable"
|-
! <br>
|-
! <br><br>
|-
! <br>
|-
Sorting the wikitext of a tableOne difficult way to sort the wikitext itself by a certain column is to use the following 'trick'. You can make an auxiliary sortable table containing the wikitext for the original table, and sort it. You can then replace the original wikitext by this sorted wikitext. Unfortunately this method is anything but quick and easy. The heavy modifications needed make it unsuitable for larger tables, while small tables generally are sorted faster by hand. Example: Original table:
Auxiliary table: {|class="wikitable sortable"
!demo
{|class="wikitable sortable"
!header
|-
||-
| 9
|-
||-
|12
|-
||-
|11
|}
|}
Now you can sort the above table, and copy the rendered text to the edit box. After deleting the "header" line, this renders as a new defaultly sorted table:
Alphabetic sorting orderSort the following table to see an example of the alphabetic sort order. Note that sorting is case-insensitive: the two-character entries such as A1 demonstrate that A and a are at the same position.
Sorting with increase/decrease/steady templates
To enable sorting of cells with Template:Increase, Template:Decrease or Template:Steady, add a sort key, e.g. {{increase|2}}2, {{decrease|-1}}1 or {{steady|0}}. To fix an existing table, use Search and replace (right icon in the Advanced toolbar) with Treat search string as a regular expression selected to do the following replacements:
See also
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Portal di Ensiklopedia Dunia
