Sandbox
Try out the CSDMS Wiki! This area is meant to type anything and see how it appears in the wiki. Make sure to clean up this area after using, so an other person starts with a clean sheet again.
To edit, click here or the "edit" button at the left side of the page in the "page edit toolkit", make your changes in the dialog box, and click the "Save page" button when you are finished. Please refrain from adding material that is any way offensive, that is copyrighted, or that is at all libelous.
Have fun!
| numbers
|
| 123,456,789
|
| 2,500,000,000
|
| 300,000,000
|
| 3,000,000 abc
|
| 5,000,000
|
| 2,000 def
|
| -4,000
|
| ghi
|
| -9,999
|
| 4,000
|
| 9,999
|
| 800,000
|
| 900,000
|
|
| numbers
|
| 123 564,589.7e12
|
| 9
|
| -80
|
| 80 abc 5
|
| abc 80
|
| 70
|
| 600
|
|
| first alphabetic, later also numeric mode
|
| 123.4 ghi
|
| 2,500,000,000
|
| 300,000,000
|
| 3,000,000 abc
|
| 5,000,000
|
| 2,000 def
|
| 4,000
|
| 9,999
|
| 800,000
|
| 900,000
|
|
| currencies
|
| $ 9
|
| $ 80
|
| $ 70
|
| $ 600
|
|
| currencies
|
| € 9
|
| € 80
|
| € 70
|
| € 600
|
|
| currencies
|
| £ 9
|
| £ 80
|
| £ 70
|
| £ 600
|
|
| currencies
|
| ¥ 9
|
| ¥ 80
|
| ¥ 70
|
| ¥ 600
|
|
| comparison
|
| a 9
|
| a 80
|
| a 70
|
| a 600
|
|
| comparison
|
| e 9
|
| e 80
|
| e 70
|
| e 600
|
|
|
|
The example with "a" gives alphabetic sorting; that with "e" ditto, the data are not mistaken for numbers in scientific format.
| mixed notations
|
| 12 or 13 sm=n
|
| -12 (retrograde)
|
| 12 (?)
|
| ca. 12
|
| ?
|
| 1.4285714285714E+17
|
| 1000000000000000000
|
| -1000000000000000000
|
| .0000000000000000001
|
| -.0000000000000000001
|
| -1.4285714285714E+17
|
| 1.4285714285714E-13
|
| -1.4285714285714E-13
|
| 89 123 456 788
|
| 89,123,456,789
|
| 333
|
| 1e10
|
| e 9
|
| e 80
|
| e 70
|
| e 600
|
| 999e9
|
| 88e80
|
| 7e270
|
| 999e-9
|
| 88e-80
|
| 7e-270
|
| 4Template:E
|
| -999e9
|
| −999e9
|
| -88e80
|
| -7e270
|
| -999e-9
|
| -88e-80
|
| -7e-270
|
| e3
|
| -e3
|
| 1e3
|
| e9
|
| e80
|
| e270
|
| 2Template:E
|
| 7Template:E
|
| 6e11
|
| 8e11
|
| 7Template:E
|
| -7Template:E
|
| -7Template:E
|
| 3Template:E
|
| 4Template:E
|
|
| first number in each element counts
|
| 7-4
|
| 2
|
| 4
|
| 22/7
|
| 111
|
|
|
| mixed notations
|
| 14
|
| -14
|
| 11
|
| -12 (retrograde)
|
| 12 or 13
|
| 12 (?)
|
| ca. 12
|
| 12 (approx.)
|
| ?
|
|
The first example demonstrates that text is positioned at zero, and that e.g. e3 for 1000 is not allowed; use 1e3 instead. Using Template:Tim, a number in scientific notation can be displayed with a superscript, while still allowing numeric sorting (compare the method described in the next section). It also shows that "-" should be used, not "−". The first element "12 or 13 sm=n" has a visible "sm=n", although it is normally made invisible; when this element is at the top, numeric sorting mode applies.
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 "ca. 12" sorts at 0, as opposed to 12 with some text after it, which sorts at 12. In the latter case an invisible "sm=n" needs to be put at the end, in case such an element arrives at the top of a column, which would otherwise cause alphabetic sorting mode.
Sortable version of Template:Mlw, using smn to specify numeric sort mode:
