Format number with thousandseparator?

Thanks!

I ended up with this one, but yours is shorter (= better).

String FormatStringAsThousandSeparated(String number)
{
Byte[] bytes = number.toByteArray();
Byte[] newBytes;

Integer index = 0;
for (Integer i = bytes.length()-1; i >= 0; i--)
{
if (index % 3 == 0 && index > 0)
newBytes.pushFront(Byte(32)); //32 = whitespace. 46 = Period
index++;
newBytes.pushFront(bytes[i]);

}
return String(newBytes).stripLeading(" ");
}

Hi,

I don't know if this is of any use to anyone, but I have created two functions for this base on Sverre's code above, one for an Integer number, and one for a Float.

#setLanguageLevel 4;

String FormatIntegerWithThousandSeparator(Integer inputNumber, String thousandSeperator)
{

  //Convert The Number Into A String
  String strInputNumber = inputNumber.toString();

  //Loop Back In Blocks Of Three, And Add Thousand Seperators
  Integer len = strInputNumber.getLength() - 3;
  
  while (len > 0)
  {
    strInputNumber = strInputNumber.subString(0, len) + thousandSeperator + strInputNumber.subString(len, strInputNumber.getLength() - len);
    len -= 3;
  }

  //Return Formatted Number
  Return strInputNumber;
}

String FormatFloatWithThousandSeparator(Float inputNumber, String thousandSeperator, Integer noOfDecimalPlaces)
{
  //Split The Number Into A Whole Number And It's Decimals
  Integer inputNumberWholeNumber = inputNumber.floor();
  Float remainingValue = inputNumber - inputNumberWholeNumber;
  String strRemainingValue = remainingValue.toString(noOfDecimalPlaces);

  //Format The Whole Number Into The Thousand Seperators And Add Back The Decimals
  Return FormatIntegerWithThousandSeparator(inputNumberWholeNumber, thousandSeperator) + strRemainingValue.subString(1, strRemainingValue.getLength());
}

//Test Functions
print(FormatIntegerWithThousandSeparator(123456789, ",") + '
');
print(FormatFloatWithThousandSeparator(123456789.99, ",", 2) + '
');

print(FormatIntegerWithThousandSeparator(325233585, ",") + '
');
print(FormatFloatWithThousandSeparator(325233585.22, ",", 2) + '
');
print(FormatFloatWithThousandSeparator(325233585.00, ",", 2) + '
');

Trevor