Forum Discussion

dpeterson157's avatar
dpeterson157
Contributor
11 years ago

Use aqString.format to generate a number with the thousands separator

It can't possibly be this hard, but I can't for the life of me figure out how to do it! What I want: aqString.Format("???", 1) = 1 aqString.Format("???", 100) = 100 aqString.Format...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    11 years ago
    Hi David,

     

    As far as I know, aqString.Format cannot do this, but you can use the .NET System.Format method instead:
    // JScript
    dotNET.System.String.Format("{0:n0}", 1000).OleValue

    It uses the current locale's thousands separator - comma/space/period etc.

     

    If you run tests on different locales and want to always format with a comma, you can use something like this:
    // JScript
    function ToString(number)
    {
      var culture = dotNET.System_Globalization.CultureInfo.zctor("en-US");
      var args = dotNET.System_Collections.ArrayList.zctor();
      args.Add(number);
      var str = dotNET.System.String.Format_3(culture, "{0:n0}", args.ToArray()).OleValue;
      return str;
    }
TanyaYatskovska's avatar
TanyaYatskovska
SmartBear Alumni (Retired)
11 years ago
Hi David,

 

As far as I know, aqString.Format cannot do this, but you can use the .NET System.Format method instead:
// JScript
dotNET.System.String.Format("{0:n0}", 1000).OleValue

It uses the current locale's thousands separator - comma/space/period etc.

 

If you run tests on different locales and want to always format with a comma, you can use something like this:
// JScript
function ToString(number)
{
  var culture = dotNET.System_Globalization.CultureInfo.zctor("en-US");
  var args = dotNET.System_Collections.ArrayList.zctor();
  args.Add(number);
  var str = dotNET.System.String.Format_3(culture, "{0:n0}", args.ToArray()).OleValue;
  return str;
}