emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Orgmode] Query: Nested sort in table?


From: Christian Moe
Subject: [Orgmode] Query: Nested sort in table?
Date: Tue, 14 Sep 2010 12:44:41 +0200
User-agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.5; en-US; rv:1.9.2.9) Gecko/20100825 Thunderbird/3.1.3

Hi,

Is there a technique or strategy to get nested sorts in Org tables, i. e. sorting first by column B, then by column A, ...?

e.g. a list of publications sorted by title:

| Author    | Year | Title            | Type    |
|-----------+------+------------------+---------|
| Smith, J. | 2006 | Mazes for mice   | Article |
| Jones, S. | 2003 | Mice for Dummies | Book    |
| Smith, J. | 2002 | Rodents          | Book    |
| Jones, S. | 2007 | Say 'Cheese'!    | Article |
| Jones, S. | 2000 | Pet care         | Book    |

For bibliographical order you would want to sort first by author, then by year (ascending or sometimes adecending). In other circumstances you might also want to sort by type first of all, to have separate lists of books and articles. You can sort by author

| Author    | Year | Title            | Type    |
|-----------+------+------------------+---------|
| Jones, S. | 2003 | Mice for Dummies | Book    |
| Jones, S. | 2007 | Say 'Cheese'!    | Article |
| Jones, S. | 2000 | Pet care         | Book    |
| Smith, J. | 2006 | Mazes for mice   | Article |
| Smith, J. | 2002 | Rodents          | Book    |

but how to get the works of each author sorted by date? Manually selecting a region from "2003" to the end of the "Jones" lines, sorting, and then selecting a region from "2006" to the end of the "Smith" lines, and sorting again, works:

| Author    | Year | Title            | Type    |
|-----------+------+------------------+---------|
| Jones, S. | 2000 | Pet care         | Book    |
| Jones, S. | 2003 | Mice for Dummies | Book    |
| Jones, S. | 2007 | Say 'Cheese'!    | Article |
| Smith, J. | 2002 | Rodents          | Book    |
| Smith, J. | 2006 | Mazes for mice   | Article |

-- but is there a shortcut?

Yours,
CM



reply via email to

[Prev in Thread] Current Thread [Next in Thread]