Re: Sorting table columns (*not* content)

From: brian powell <briangpowellms@gmail.com>
To: Juan Pechiar <juan@pechiar.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: Sorting table columns (*not* content)
Date: Mon, 1 Nov 2010 11:39:53 -0400	[thread overview]
Message-ID: <AANLkTineAcbqgubTBt-u6L_R-kDi2A_cOfrDG2KPVjf-@mail.gmail.com> (raw)
In-Reply-To: <20101101144342.GA2450@soloJazz.com>

[-- Attachment #1.1: Type: text/plain, Size: 2044 bytes --]

Jeff Horn seems to be explaining specifics of how to do some nitty-gritty
manipulations--he mentions (quoting the manual) methods for yanking, Ccxy

The methods Jeff expressed are useful for the question posed.

I recommend rectangle-kill and rectangle-yank--Cxrk and Cxry to solve this
(in a very simple albeit possibly faster or slower way--depending on how
many columns you want to move/sort---moving column/rectangle 3 to the 3rd
position in this case--took a few seconds)

I tested Juan's method/defun---works grrrrreat!!
Thanks Juan

P.S. I did lose the hlines like you reported; but, to put the line back was
3 key strokes: |-Tab

On Mon, Nov 1, 2010 at 10:43 AM, Juan Pechiar <juan@pechiar.com> wrote:

> If you don't mind losing h-lines, you can transpose the table, sort
> rows, and transpose back.
>
> This code (which I previously posted to the list) transposes a table:
>
> #+begin_src: emacs-lisp
>
> (defun org-transpose-table-at-point ()
>  "Transpose orgmode table at point, eliminate hlines"
>  (interactive)
>  (let ((contents (apply #'mapcar* #'list
>                         (remove-if-not 'listp  ;; remove 'hline from list
>                                        (org-table-to-lisp))))  ;; signals
> error if not table
>        )
>    (delete-region (org-table-begin) (org-table-end))
>    (insert (mapconcat (lambda(x) (concat "| " (mapconcat 'identity x " | "
> ) "  |\n" ))
>                       contents
>                       ""))
>    (org-table-align)
>    )
> )
>
> #+end_src
>
> Regards,
> .j.
>
> On Mon, Nov 01, 2010 at 02:42:55PM +0100, Gary wrote:
> > Is there any way to sort the columns of a table, such that for example
> >
> > | Col 3 | Col 1 | Col 2 |
> >
> > can be converted to
> >
> > | Col 1 | Col 2 | Col 3 |
> > |-------+-------+-------|
> > | ...   | ...   | ...   |
> >
> > ?
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>

[-- Attachment #1.2: Type: text/html, Size: 2847 bytes --]

[-- Attachment #2: Type: text/plain, Size: 201 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode