Thousands separator in a number string

Question

Hello All, 
 Thank you in advance for any replies. This forum has a been a great resource to getting my little widget up and running. I'm not a terribly experienced developer outside of VB so sorry if this is obvious. I searched the forum and didn't really come across a solution. 
 Basic idea is I'm retrieving a dollar value from an API. I've got this part down, and passed to a variable and formatted to give me 2 decimal points... 
 My question is there a (preferably easy) way to add thousands separators? 
 My 'price' is coming through as 4941515.1561531 I'm formatting it to get $ 4941515.16 What I would like for readability is $ 4,941,515.16 
 Ideas? Thanks everyone! 
 
 function onReceivePrice(responseCode, data) {
 if(responseCode == 200) {
 Price = data["bpi"]["USD"]["rate_float"].toFloat();
 L1 = "$ "+Price.format("%.2f");
 L2 = "$ "+(Price*Port).format("%.2f");
 
 //! blah blah blah....

Travis.ConnectIQ · Accepted Answer

If you are supporting this language for multiple locales, this is a can of worms. Not all locales use comma as the decimal separator. Not all locales put the separator in the thousands place. Heck, not all locales use the $ symbol... 
 If you don't care about that, you should be able to generate a string for the whole dollar amount, insert the separators, and then concatenate that with the fractional dollars. 
 function format_money(dollar_sign, value, decimal_spacing, decimal_separator, decimal_point) {
 var whole = value.toNumber();
 var frac = ((value - whole) * 100).format("%02d");

 var digits = [];
 
 var count = 0;
 while (whole != 0) {
 var digit = (whole % 10).toString();
 whole /= 10;
 
 if (count == decimal_spacing) {
 digits.add(decimal_separator);
 count = 0;
 }
 ++count;
 
 digits.add(digit);
 }
 
 digits = digits.reverse();
 
 whole = "";
 for (var i = 0; i < digits.size(); ++i) {
 whole += digits[i];
 }

 return Lang.format("$1$ $2$$3$$4$", [ dollar_sign, whole, decimal_point, frac ]);
}

function format_money_us(value) {
 return format_money("$", value, 3, ",", ".");
} 
 This will be useful for some locales, but not all.

Thousands separator in a number string

Top Replies

All Replies