formatting number

[Amol Juvatkar]

hi ,
i want to display number as format 99,99,999.99

I am using DecimalFormat("##,##,###.00")

but sill it is showing output as 9,999,999.99

kindly suggest me if there is another solution.

my code is like this,

   
double num = 99999999.23;
String format1 = "##,##,###.00" ;  
DecimalFormat format = new DecimalFormat(format1);
System.out.println("~~~~"+format.format(num));

thanks,
Amol

[Srinivas Kalvala]

Hello,

See the Java Source for DecimalFormat(String) Parameter Constructor. It depends on the Locale Object.

 
 /**
     * Creates a DecimalFormat using the given pattern and the symbols
     * for the default locale. This is a convenient way to obtain a
     * DecimalFormat when internationalization is not the main concern.
     * <p>
     * To obtain standard formats for a given locale, use the factory methods
     * on NumberFormat such as getNumberInstance. These factories will
     * return the most appropriate sub-class of NumberFormat for a given
     * locale.
     *
     * @param pattern A non-localized pattern string.
     * @exception NullPointerException if <code>pattern</code> is null
     * @exception IllegalArgumentException if the given pattern is invalid.
     * @see java.text.NumberFormat#getInstance
     * @see java.text.NumberFormat#getNumberInstance
     * @see java.text.NumberFormat#getCurrencyInstance
     * @see java.text.NumberFormat#getPercentInstance
     */
    public DecimalFormat(String pattern) {
        // Always applyPattern after the symbols are set
        this.symbols = new DecimalFormatSymbols(Locale.getDefault());
        applyPattern(pattern, false);
    }
 

So, change your locale and try it.

[Tim LeMaster]

From ye old JavaDoc -

The grouping separator is commonly used for thousands, but in some countries it separates ten-thousands. The grouping size is a constant number of digits between the grouping characters, such as 3 for 100,000,000 or 4 for 1,0000,0000. If you supply a pattern with multiple grouping characters, the interval between the last one and the end of the integer is the one that is used. So "#,##,###,####" == "######,####" == "##,####,####".

[Ken Blair]

That's not going to help. Read the DecimalFormat documentation, specifically this excerpt:

The grouping separator is commonly used for thousands, but in some countries it separates ten-thousands. The grouping size is a constant number of digits between the grouping characters, such as 3 for 100,000,000 or 4 for 1,0000,0000. If you supply a pattern with multiple grouping characters, the interval between the last one and the end of the integer is the one that is used. So "#,##,###,####" == "######,####" == "##,####,####".

It would appear that what you hope to accomplish isn't possible with DecimalFormat. The last grouping in the format is used for all groupings, if you want them to be different I guess you'll have to find one or roll your own.

[Campbell Ritchie]

I agree you aren't using a standard thousands separator format.

If all else fails, try integer division and remainder operators. But make sure you don't stray outwith the bounds of the int type:-

double number;
int wholeNumber = (int)number;
System.out.printf("The number is %2d,%02d,%03d%3.2f%n",
   wholeNumber / 100000, wholeNumber % 100000 / 1000, wholeNumber % 1000, (int)(number % 1.0 * 100));

Or try using the Double class to change the number to a String, and split it into a char[] array, then print them one by one with commas as appropriate. You will have to count the digits in your numbers carefully for both methods otherwise you will get something like, "0,01,234.56."

[Amol Juvatkar]

Thanks for your help.

regards
Amol

[Alan Moore]

Here's a regex implementation of Campbell's second suggestion:

String numStr = String.valueOf(num);
numStr = numStr.replaceAll("\\d{1,2}(?=(?:\\d{2})*\\d{3}\\b)", "$0,")

[Amol Juvatkar]

Thanks Alan,

now one more doubt.

  
double num = 2133623856.42;
//String numStr = String.valueOf(num+"");// statement 1
String numStr = String.valueOf("2133623856.42");// statement 2
numStr = numStr.replaceAll("\\d{1,2}(?=(?:\\d{2})*\\d{3}\\b)", "$0,");
System.out.println("numStr "+numStr);

with
statement 1 formatting doesn't work.
but
with statement 2 it works properly.

in general both are strings only.
so what may be wrong ??

regards,
amol