LowEndBox - Cheap VPS, Hosting and Dedicated Server Deals

Commifying Numbers in Linux: Not as Easy as it Looks

CommifyToday I had a need to process large numbers of PostgreSQL database tables and report how many rows were in each.  Once I had that information, I needed to do some additional math on this data and then print it out in a nice formatted manner.  And for reasons I won’t go into, I had to use shell.

But it was all very trivial…until I got to that last part.  It involves commification.

Is that even a word?  My browser’s spell checker thinks not and it doesn’t know commify either.  While you might think commification is a 1950s word for the spread of Marxism, it means “adding commas to numbers”.  In other words, turning 100000000 into 100,000,000.

Of course, in some countries they’d look at 100,000,000 and ask why you have two decimal places.  And in India they’d expect this to be formatted as 1,00,00,00,00 which is as confused to me as 100,000,000 would be to an Indian.  But regardless of your locale, the issue is the same.

There are Linux tools to transform, chop, parse, split, join, fold, bend, substitute, replace, and apply just about any contortion to a string of letters, numbers, and symbols.  Indeed, text processing is one of Unix’s greatest strengths.  Indeed, early on that was what Unix was mainly used for.

However, at first glance, I was unable to find any simple commifier for Linux.  I have little snippets on how to do it in Python and Perl but there should be an easy way to do this on the command line.  Right?

Wrong.

Some people have written extensive scripts to do this.  Removing comments and blank lines from that script, it’s 20 lines.  20 lines of interpreted shell code just to format a number!

Fortunately, we don’t need to do this.  We can do it in a single line:

     $ echo 100000000 | sed ':a;s/\(^\|[^0-9.]\)\([0-9]\+\)\([0-9]\{3\}\)/\1\2,\3/g;ta'
     $ 100,000,000

There, that’s simple enough, right?  Let’s walk through that sed command letter by letter…wait, don’t go!  I was just kidding.  BTW, that only works for GNU sed – there are other options discussed in the sed FAQ.

But please don’t waste your time.  Let me show you the simple way that’s small enough to easily commit to memory.

Check this out:

     $ echo 100000000 | printf "%'d\n" 100000000
     $ 100,000,000

Nice!  This works in sufficiently modern versions of bash and also ksh (93+ – if you’re still using ksh88 in 2022 you need counseling).

It’s the apostrophe after the % sign that tells printf to commify.

Any suggestion that I wrote this article so I could find it the next time I google how to do this is probably accurate.

 

1 Comment

  1. Figured I’d point this out – we’d write 100000000 in Indian system as 10,00,00,000 and not 1,00,00,00,00, and read it as 10 crore.

    July 9, 2022 @ 2:06 pm | Reply

Leave a Reply

Some notes on commenting on LowEndBox:

  • Do not use LowEndBox for support issues. Go to your hosting provider and issue a ticket there. Coming here saying "my VPS is down, what do I do?!" will only have your comments removed.
  • Akismet is used for spam detection. Some comments may be held temporarily for manual approval.
  • Use <pre>...</pre> to quote the output from your terminal/console, or consider using a pastebin service.

Your email address will not be published.