From formatted to table

From formatted to table

[andrea Crotti]

I have for example a table where

| one thing     | dsjfls   |
| two things    | dslkjfls |
| three abc dej | dsf      |

And I would like to get

| one   | thing   | dsjfls   |
| two   | things  | dslkjfls |
| three | abc dej | dsf      |

I tried some simple substitutions but substituting all the spaces in
the region selected will cause problems elsewhere.  I would need to
substitute " " only in one column, is that possible?

RE: From formatted to table

[Jonathan Arkell]

I do a macros for this

Put the point on the first word of the table
Record Macro
Search for " "
Insert "|"
Tab (next column)
Tab (first column next row
Stop Recording.

Then just C-x e (run macro) until the job is done.   If you know how many lines are on the table, you can use a prefix argument with C-x e.



-----Original Message-----
From: emacs-orgmode-bounces+jonathana=criticalmass.com@gnu.org [mailto:emacs-orgmode-bounces+jonathana=criticalmass.com@gnu.org] On Behalf Of andrea Crotti
Sent: September 29, 2009 8:49 AM
To: emacs-orgmode@gnu.org
Subject: [Orgmode] From formatted to table

I have for example a table where

| one thing     | dsjfls   |
| two things    | dslkjfls |
| three abc dej | dsf      |

And I would like to get

| one   | thing   | dsjfls   |
| two   | things  | dslkjfls |
| three | abc dej | dsf      |

I tried some simple substitutions but substituting all the spaces in
the region selected will cause problems elsewhere.  I would need to
substitute " " only in one column, is that possible?



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

The information contained in this message is confidential. It is intended to be read only by the individual or entity named above or their designee. If the reader of this message is not the intended recipient, you are hereby notified that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message.

Re: From formatted to table

[Nick Dokos]

Jonathan Arkell <jonathana@criticalmass.com> wrote:

> I do a macros for this
> 
> Put the point on the first word of the table
> Record Macro
> Search for " "
> Insert "|"
> Tab (next column)
> Tab (first column next row
> Stop Recording.
> 
> Then just C-x e (run macro) until the job is done.   If you know how many l=
> ines are on the table, you can use a prefix argument with C-x e.
> 
> 
> 
> -----Original Message-----
> From: emacs-orgmode-bounces+jonathana=3Dcriticalmass.com@gnu.org [mailto:em=
> acs-orgmode-bounces+jonathana=3Dcriticalmass.com@gnu.org] On Behalf Of andr=
> ea Crotti
> Sent: September 29, 2009 8:49 AM
> To: emacs-orgmode@gnu.org
> Subject: [Orgmode] From formatted to table
> 
> I have for example a table where
> 
> | one thing     | dsjfls   |
> | two things    | dslkjfls |
> | three abc dej | dsf      |
> 
> And I would like to get
> 
> | one   | thing   | dsjfls   |
> | two   | things  | dslkjfls |
> | three | abc dej | dsf      |
> 
> I tried some simple substitutions but substituting all the spaces in
> the region selected will cause problems elsewhere.  I would need to
> substitute " " only in one column, is that possible?
> 
> 

Two things to add to Jonathan's answer:

o You don't have to know the length of the table: just mark the region
containing the table, C-x n n (narrow-to-region) and C-0 C-x e to repeat
the macro for ever or until an error occurs, whichever comes first :-)
Then widen: C-x n w


o Alternatively, "It's just text" (TM), so you can use a
sed/perl/awk/python/foo script to do arbitrary
transformations. Blasphemy, I know, but emacs doesn't have to do
everything.

You can even run the script from within emacs: mark the region and C-u
M-| (shell-command-on-region with the prefix argument specifying that
that output of the command is to replace the region) with the following
script

    sed '/|/s/[^|] /&| /'

should do the trick. It's utterly liberating to be able to use all sorts
of different tools on your file and the single, most important advantage
of org-mode when compared to all the other systems out there.

HTH,
Nick

Re: From formatted to table

[Bernt Hansen]

andrea Crotti <andrea.crotti.0@gmail.com> writes:

> I have for example a table where
>
> | one thing     | dsjfls   |
> | two things    | dslkjfls |
> | three abc dej | dsf      |
>
> And I would like to get
>
> | one   | thing   | dsjfls   |
> | two   | things  | dslkjfls |
> | three | abc dej | dsf      |
>
> I tried some simple substitutions but substituting all the spaces in
> the region selected will cause problems elsewhere.  I would need to
> substitute " " only in one column, is that possible?

Anything is possible in Emacs :) -- just look at org-mode!

This sounds like a use for a keyboard macro to me...

Position point on line 1 of the table
C-x (
C-s SPC C-s RET |
C-a C-n
C-x e
and repeat 'e' for every line in the table
then C-p C-c C-c to realign.

If you do this a lot you can save the macro or build a lisp function
that does it - repeating for the entire table.

HTH,
-Bernt