NumberFormat

This function formats a number in a defined pattern. The NumberFormat class is used to format numbers according to a specific Locale. Different countries have different standards for how they format numbers.

Format: NumberFormat(numberToformat, outputFormat, language, countryCode, groupingSeparator, decimalSeparator)

Note that language, countryCode, groupingSeparator and decimalSeparator are optional.

Examples

Case 1

If you are giving the locale, then the number format will work only for the symbols of that particular locale.

Example: {NumberFormat(12333456.7847, "##,#####.####", "en", "US")}

Output – 123,33456.7847

Case 2

If you are not providing the locale, default locale will be en-IN. Number will be formatted as per the locale’s symbols.

Example: {NumberFormat("324567.89", "PLN ###,###.##")}

Output – PLN 324,567.89

Case 3

If you want to have space as a separator in your output format, you will have to explicitly give it as a parameter.

Example: {NumberFormat("345126.7847", "## ###,####", "bg", "BG", " ")}

Output – 345 126,7847

Case 4

If you want to specify your own symbols in outputFormat, don’t provide the locale. Instead, you should mention the separator symbols as parameters to the method.

Example 1:{NumberFormat("324567.89", "PLN ### ###,##", null, null, " ", ",")}

Output – PLN324 567,89

Example 2: {NumberFormat("12333456.7847", "##,###/####", "fa", "IR", ",", "/")}

Output – 12,333,456/7847

In addition, if you need to provide a decimal in the number to be formatted, if there is no decimal in numberToformat then the output will format only the integer part.

Example 3: {NumberFormat(12337847, "##,#####.####", "en", "US")}

Output – 123,37847

Practice

Want to learn more about using this function in Provar? You can use the following sample test case to get started. Simply right-click to download NumberFormat.testcase and then drag and drop the test case into the test folder within the Navigator panel of Provar.

Note: You will need to unzip/extract the compressed file before using it in Provar.