Forum Discussion

lucky_star's avatar
lucky_star
Occasional Contributor
9 years ago

How to format Numeric using 1000 Separator ","

Hi,   Please help me to format the numeric which is used 1000 Separator ","   value1= "2,400"; value2 = "1";   value = aqConvert["VarToFloat"](value1) + aqConvert["VarToFloat"](value2);   >>...
  • joseph_michaud's avatar
    joseph_michaud
    9 years ago

    Interesting.  I could only manage to print numbers with thousand separators using the deprecated functions:

     

    // JScript
function thousand()
{
  var aaa = 1234.1;
  Log.Message(Utilities.FormatFloat("#.#,", aaa));  // 1,234.1
  Log.Message(Utilities.FormatFloat("#.#",  aaa));  // 1234.1
  Utilities.ThousandSeparator = ";";
  Log.Message(Utilities.FormatFloat("#.#,", aaa));  // 1;234.1
  Log.Message(Utilities.FormatFloat("#.#",  aaa));  // 1234.1
}
  • HKosova's avatar
    HKosova
    9 years ago
    lucky_star wrote:

    In this case, I expect that the result is format result as "1,234.10" , but the result is returned "1,234.1"

    So how can I format decimal places = 2 ?

    Log.Message(Utilities.FormatFloat("#.00,", 1234.1)); // 1,234.10

    should do the trick.

     

    Or if you would like to avoid using the deprecated Utilities functions, try this: 

    var number = 1234.1;
    var str = dotNET.System.String.Format("{0:n2}", number).OleValue; // 1,234.10
Ravik's avatar
Ravik
Super Contributor
9 years ago

Function fun_RemoveSplChar(strToClean)　

Dim objRegExp, outputStr

Set objRegExp = New Regexp

objRegExp.IgnoreCase = True

objRegExp.Global = True

objRegExp.Pattern = "[($?*"",\\<>&#~%{}+_@:\/!;]+"

outputStr = objRegExp.Replace(strToClean, "")

fun_RemoveSplChar = outputStr　

End Function

 

intNumber= fun_RemoveSplChar(1,000)

 

 

Use above code it will remove all specified special character including , it will format your values like (1,000 = 1000)

 

This may help you :)

  • joseph_michaud's avatar
    joseph_michaud
    Moderator
    9 years ago

    Interesting.  I could only manage to print numbers with thousand separators using the deprecated functions:

     

    // JScript
function thousand()
{
  var aaa = 1234.1;
  Log.Message(Utilities.FormatFloat("#.#,", aaa));  // 1,234.1
  Log.Message(Utilities.FormatFloat("#.#",  aaa));  // 1234.1
  Utilities.ThousandSeparator = ";";
  Log.Message(Utilities.FormatFloat("#.#,", aaa));  // 1;234.1
  Log.Message(Utilities.FormatFloat("#.#",  aaa));  // 1234.1
}
    • lucky_star's avatar
      lucky_star
      Occasional Contributor
      9 years ago

      Hi joseph_michaud,

       

      function thousand()
{
Utilities.ThousandSeparator = ",";
var num = 1234.10;
var res = Utilities.FormatFloat("#.#,", num);
Log["Message"](res);
}

      In this case, I expect that the result is format result as "1,234.10" , but the result is returned "1,234.1"

      So how can I format decimal places = 2 ? 

       

      Thanks for your helping,

       

      • HKosova's avatar
        HKosova
        SmartBear Alumni (Retired)
        9 years ago
        lucky_star wrote:

        In this case, I expect that the result is format result as "1,234.10" , but the result is returned "1,234.1"

        So how can I format decimal places = 2 ?

        Log.Message(Utilities.FormatFloat("#.00,", 1234.1)); // 1,234.10

        should do the trick.

         

        Or if you would like to avoid using the deprecated Utilities functions, try this: 

        var number = 1234.1;
        var str = dotNET.System.String.Format("{0:n2}", number).OleValue; // 1,234.10