align.el: how to align space delimited text tables?

align.el: how to align space delimited text tables?

[Benjamin Rutt]

I have a buffer in text-mode that I'd like to align using align.el.
Here are the contents:

    max 4096 cs  70 ap_mp  9 t  55% np 63 ap 63
    max 6291.456 cs  70 ap_mp  9 t  55% np 63 ap 63
    max 8192 cs  70 ap_mp  9 t  55% np 63 ap 63

I'd like to align the fields to the following:

    max 4096     cs  70 ap_mp  9 t  55% np 63 ap 63
    max 6291.456 cs  70 ap_mp  9 t  55% np 63 ap 63
    max 8192     cs  70 ap_mp  9 t  55% np 63 ap 63

Anyone have a good recipe for this?

BTW, I'm using the align.el that comes with Emacs 21.
-- 
Benjamin

Re: align.el: how to align space delimited text tables?

[John Wiegley]

>>>>> On Thu Dec 19, Benjamin writes:

> I'd like to align the fields to the following:

>     max 4096 cs 70 ap_mp 9 t 55% np 63 ap 63 max 6291.456 cs 70
> ap_mp 9 t 55% np 63 ap 63 max 8192 cs 70 ap_mp 9 t 55% np 63 ap 63

> Anyone have a good recipe for this?

Without a delimiter, there is no way for align.el to figure this
out.  It is only regexp based, not a true parser.

It will align TeX tables, for example, because those use & as a
delimiter.

John

Re: align.el: how to align space delimited text tables?

[Miles Bader]

John Wiegley <johnw@gnu.org> writes:
> >     max 4096 cs 70 ap_mp 9 t 55% np 63 ap 63 max 6291.456 cs 70
> > ap_mp 9 t 55% np 63 ap 63 max 8192 cs 70 ap_mp 9 t 55% np 63 ap 63
> 
> > Anyone have a good recipe for this?
> 
> Without a delimiter, there is no way for align.el to figure this
> out.  It is only regexp based, not a true parser.

In this case, the delimiter would appear to be whitespace (e.g. [ \t]+);
does align.el not support that well?

-Miles
-- 
Ich bin ein Virus. Mach' mit und kopiere mich in Deine .signature.

Re: align.el: how to align space delimited text tables?

[Benjamin Lewis]

On 20 Dec 2002, Miles Bader wrote:

> John Wiegley <johnw@gnu.org> writes:
>>> max 4096 cs 70 ap_mp 9 t 55% np 63 ap 63 max 6291.456 cs 70
>>> ap_mp 9 t 55% np 63 ap 63 max 8192 cs 70 ap_mp 9 t 55% np 63 ap 63
>> 
>>> Anyone have a good recipe for this?
>> 
>> Without a delimiter, there is no way for align.el to figure this
>> out.  It is only regexp based, not a true parser.
> 
> In this case, the delimiter would appear to be whitespace (e.g. [ \t]+);
> does align.el not support that well?

In this case, it appears that not all the spaces are to be considered as
delimiters.  You have to say something like "treat every other space as a
delimiter".  

-- 
Benjamin Lewis

Now is the time for all good men to come to.
                -- Walt Kelly

Re: align.el: how to align space delimited text tables?

[John Wiegley]

>>>>> On Thu Dec 19, Miles writes:

> In this case, the delimiter would appear to be whitespace (e.g. [
> \t]+); does align.el not support that well?

Try passing that regexp to M-x align-regexp, see if it works...

John

Re: align.el: how to align space delimited text tables?

[Kevin Rodgers]

Benjamin Rutt wrote:

> I have a buffer in text-mode that I'd like to align using align.el.
> Here are the contents:
> 
>     max 4096 cs  70 ap_mp  9 t  55% np 63 ap 63
>     max 6291.456 cs  70 ap_mp  9 t  55% np 63 ap 63
>     max 8192 cs  70 ap_mp  9 t  55% np 63 ap 63
> 
> I'd like to align the fields to the following:
> 
>     max 4096     cs  70 ap_mp  9 t  55% np 63 ap 63
>     max 6291.456 cs  70 ap_mp  9 t  55% np 63 ap 63
>     max 8192     cs  70 ap_mp  9 t  55% np 63 ap 63
> 
> Anyone have a good recipe for this?


1. Mark the region (C-x h if the text is the entire contents of the buffer,
    or the buffer has already been narrowed to the text).

2. Replace the region:

	C-u M-|
	awk '{printf("%s %-8s %s  %s %s  %s %s %s %s %s %s %s\n", C-q C-j
	             $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12)}' RET

-- 
<a href="mailto:&lt;kevin.rodgers&#64;ihs.com&gt;">Kevin Rodgers</a>

RE: align.el: how to align space delimited text tables?

[Victor Kirk]

>    max 4096 cs  70 ap_mp  9 t  55% np 63 ap 63
>    max 6291.456 cs  70 ap_mp  9 t  55% np 63 ap 63
>    max 8192 cs  70 ap_mp  9 t  55% np 63 ap 63

> I'd like to align the fields to the following:

>    max 4096     cs  70 ap_mp  9 t  55% np 63 ap 63
>    max 6291.456 cs  70 ap_mp  9 t  55% np 63 ap 63
>    max 8192     cs  70 ap_mp  9 t  55% np 63 ap 63

> Anyone have a good recipe for this?

Try googling for ws-align.el by Matthias Helmling, this 
provides align-cols which does exactly what you want.

--
Vic
This message, including attachments, is intended only for the use by the
person(s) to whom it is addressed. It may contain information which is
privileged and confidential. Copying or use by anybody else is not
authorised. If you are not the intended recipient, please contact the sender
as soon as possible. The views expressed in this communication may not
necessarily be the views held by Serco Integrated Transport.