Tutorials

sort

sort {column} …

Sort a table's rows.

If no columns are specified, the rows are collated by comparing their values from left to right.

If columns are specified, the rows are collated using the specified columns only, in the order that they appear after the sort keyword.

The special keywords first and last are interpreted as the first (left-most) and last (right-most) columns of the table.

Use :first, :last, :before or :after to reference columns named first, last etc..

See also Sorting

psv sort

• sort each table using the first column

psv sort value

• Sort each table by its value column
• Any tables wihtout a value column are sorted by their first column.

psv sort symbol value

• Sort each table by their symbol and then value columns

psv sort value symbol

• Sort each table by their value and then symbol columns
• Note that the value column appears after the symbol column, so they are given additional priority markers to ensure the correct colation order.

psv sort value~v

• Sort each table by their value column, in descending order