First, the idea: you have a number, you want it formatted a certain way. Here’s how:
var dollars = 5.001; alert(dollars.numberFormat("$0.00"); // result: "$5.00" var percent = .08134; alert(percent.numberFormat("0.00%"); // result: "8.13%" var bignum = 12831242485472; alert(bignum.numberFormat("0,0,, million"); // result: "12,831,243 million"
My custom date formatting code used PHP’s date-formatting syntax because it’s much less context-sensitive and (I think) more useful than Microsoft’s, but my number-formatting syntax is similar to Microsoft’s because it’s much more widely used and I don’t see an existing, better alternative. Rather than documenting it separately, I’ll just point you to the (poor quality) Microsoft documentation for the .NET Custom Numeric Format Strings functionality, and list the differences from my implementation:
Rounding works differently in multi-section format strings. In .NET with a two-section string, > If the number to be formatted is negative, but becomes zero after rounding according to the format in the second section, then the resulting zero is formatted according to the first section. This is not true in my code – the number is formatted according to its value, and once the code decides which section applies, that section will be used no matter what happens during rounding.
Question marks are digit placeholders just like the number sign (
#), but if there’s no digit to insert, they get replaced with spaces, not removed. They can be used for space-padding, which might be useful for, say, accounting notation.
You don’t have to enter quotes around strings that should be mixed in with the number placeholders. In fact, my syntax is much more permissive than the Microsoft syntax: anything can go anywhere. You can put arbitrary strings smack in the middle of your number if you want.
It’s not internationalized.
I’ve only implemented a subset of the various number-formatting syntaxes I’ve seen in spreadsheets and so forth. The subset is about 85% complete in my opinion. However, I think it’s functionally about 99% complete, which means I think 99% of the time you want to format a number, it will do what you want. The tradeoff is simplicity and speed. Number formatting is actually much more difficult than date formatting, and I’ve tried to keep the code sane.
Of course there’s the obligatory demo page, too.
About The Author
Baron is the founder and CEO of VividCortex. He is the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. Baron contributes to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.