Formatting a number into #,###,###?

[Jasoco]

I don't need negative numbers. So the one-line solution works. I only use it for money and later XP.

[Robin]

I don't need negative numbers. So the one-line solution works. I only use it for money and later XP.

So no debts?

[Jasoco]

This isn't Sim City.

[Robin]

Yeah, you'd need more llamas for that.

[pekka]

I removed my postings from this thread in order to not confuse people.

[kikito]

Your definition of incorrect is incorrect.

[Jasoco]

Okay.. I'm bumping my thread to further ask for help.

How can I format a number into a ##,###.## format? Note the decimal and two decimal places at the end. Once again it's for money, but I'm going to be realistic this time and allow cents into the picture instead of whole dollars.

[vrld]

As a one-liner:

Code: Select all

string.format("%.2f", number):reverse():gsub("(%d%d%d)(%d)", "%1,%2"):reverse()

For example, if number = 1234.5, it works as following:

• string.format("%.2f", number) -- exactly two digits after the decimal point: "1234.50"
• :reverse() -- "05.4321"
• :gsub("(%d%d%d)(%d)", "%1,%2") -- add a comma after three consecutive decimals.
  the %2 ensures right behavior for numbers like 123, 123456, ... -> result "05.432,1"
• :reverse() -- "1,234.50"

[thelinx]

That fails with big numbers.

When it should be ###,###,###,###.##, it becomes #,####,####,###.##.

[vrld]

Damnit. I hoped to avoid another gsub. This works, however:

Code: Select all

string.format("%.2f", number):reverse():gsub("(%d%d%d)", "%1,"):reverse():gsub("^,?", "")