Changes: Align numbers at decimal point

Revision as of 05:54, 13 July 2012

Please review this tip:

This tip was imported from vim.org and needs general review.
You might clean up comments or merge similar tips.
Add suitable categories so people can find the tip.
Please avoid the discussion page (use the Comments section below for notes).
If the tip contains good advice for current Vim, remove the {{review}} line.

Duplicate tip

This tip is very similar to the following:

These tips need to be merged – see the merge guidelines.

Tip 893 Printable Monobook Previous Next

created 2005 · complexity intermediate · author Michael Fitz · version 5.7

Suppose you have some numbers in an ugly format:

You want to have them nice aligned with 5 decimals written out.

First, we align any line left to the beginning:

:%s§^\s*§§

123
2.5678
-13.44
100.5
+47.11

Now we split at the decimal-point (if any) and shift the fractional part wide to the right and add five '0' at the end (because we want 5 fractional digts).

:%s§\([-+]\?\d\+\)\.\?\(\d*$\)§\1                        !\200000§

123                        !00000
2                        !567800000
-13                        !4400000
100                        !500000
+47                        !1100000

This tricky substitue aligns the fractional part at column 15:

:%s§\%15c\s*!§!§

123           !00000
2             !567800000
-13           !4400000
100           !500000
+47           !1100000

Now we shift the integral part back by exchanging it with leading spaces (and replacing '!' by decimal-point):

:%s§\(^\S*\)\(\s*\)!§\2\1.§

           123.00000
             2.567800000
           -13.4400000
           100.500000
           +47.1100000

Now we truncate each fractional part to 5 digits:

:%s§\%21c\d*§§

           123.00000
             2.56780
           -13.44000
           100.50000
           +47.11000

Finally we add a '+'-sign where it's missing:

:%s§\s\(\d\)§+\1§

          +123.00000
            +2.56780
           -13.44000
          +100.50000
           +47.11000

I usually use the (german) paragraph-sign '§' to surround the substitute-patterns, because this letter is very seldom used in any IT-related context.

Comments

See VimTip139 for AlignMaps which provides the \anum (actually <Leader>anum) to do something similar:

It doesn't append the zeros, just does a numeric alignment. \anum also handles the use of commas instead of periods, European style.

@@ Line 1: / Line 1: @@
 {{review}}
 {{Duplicate|139|894|570}}
+{{TipImported
-{{Tip
 |id=893
+|previous=892
-|title=Aligning numbers at decimal-point
+|next=894
-|created=March 10, 2005 6:37
+|created=2005
 |complexity=intermediate
 |author=Michael Fitz
 |version=5.7
 |rating=3/5
+|category1=Usage
-|text=
+|category2=
-To see the _really_ alignment you should use a fixedsized font (eg. FixedSys on Windows) or mark this all and copy it into vim!
+}}
-Suppose, you've gotten some numbers in a ugly format:
+Suppose you have some numbers in an ugly format:
 <pre>
----BEG
 .5678
@@ Line 20: / Line 20: @@
 .5
   +47.11
----END
 </pre>
 You want to have them nice aligned with 5 decimals written out.
 First, we align any line left to the beginning:
 <pre>
 :%s§^\s*§§
----BEG
 .5678
@@ Line 35: / Line 34: @@
 .5
 +47.11
----END
 </pre>
-Now we split at the decimal-point (if any) and shift the fractional part wide to the right and add five '0' at the end (because we want 5 fractional digts).
+Now we split at the decimal-point (if any) and shift the fractional part wide to the right and add five '0' at the end (because we want 5 fractional digts).
-(The decimal-point has been replaced by '!' for simpleness: you are not forced to escape '!' :-)
 <pre>
 :%s§\([-+]\?\d\+\)\.\?\(\d*$\)§\1                        !\200000§
----BEG
 !00000
 !567800000
@@ Line 49: / Line 45: @@
 !500000
 +47                        !1100000
----END
 </pre>
 This tricky substitue aligns the fractional part at column 15:
 <pre>
 :%s§\%15c\s*!§!§
----BEG
 !00000
 !567800000
@@ Line 61: / Line 56: @@
 !500000
 +47           !1100000
----END
 </pre>
-Now we shift the integral part back by exchanging it with leading spaces (and by the mean replacing '!' by decimal-point):
+Now we shift the integral part back by exchanging it with leading spaces (and replacing '!' by decimal-point):
 <pre>
 :%s§\(^\S*\)\(\s*\)!§\2\1.§
----BEG
 .00000
 .567800000
@@ Line 73: / Line 67: @@
 .500000
            +47.1100000
----END
 </pre>
 Now we truncate each fractional part to 5 digits:
 <pre>
 :%s§\%21c\d*§§
----BEG
 .00000
 .56780
@@ Line 85: / Line 78: @@
 .50000
            +47.11000
----END
 </pre>
 Finally we add a '+'-sign where it's missing:
 <pre>
 :%s§\s\(\d\)§+\1§
----BEG
           +123.00000
             +2.56780
@@ Line 98: / Line 89: @@
           +100.50000
            +47.11000
----END
 </pre>
-Looks now very nice, doesn't it?
+I usually use the (german) paragraph-sign '§' to surround the substitute-patterns, because this letter is very seldom used in any IT-related context.
+==Comments==
-}}
+See [[VimTip139]] for AlignMaps which provides the <code>\anum</code> (actually <Leader>anum) to do something similar:
-== Comments ==
-Addendum to this tip:
-I usually use the (german) paragraph-sign '§' to surround the substitute-patterns, because this letter is very seldom used in any IT-related context ;-)
-'''Anonymous'''
-, March 10, 2005 6:40
-----
-FYI: AlignMaps provides the \anum (actually &lt;Leader&gt;anum) to do something similar:
 <pre>
@@ Line 118: / Line 100: @@
 -13.44
 .5
 +47.11
 </pre>
-It doesn't append the zeros, just does a numeric alignment. \anum also handles the use of commas instead of periods, European style.
+It doesn't append the zeros, just does a numeric alignment. <code>\anum</code> also handles the use of commas instead of periods, European style.
-NdrOchip--AT--ScampbellPfamily.AbizM - NOSPAM
-, March 10, 2005 12:50
 ----
-<!-- parsed by vimtips.py in 0.530612  seconds-->
-[[Category:Usage]]