number-formatting

How to parse number string containing commas into an integer in java?

by

Is this comma a decimal separator or are these two numbers? In the first case you must provide Locale to NumberFormat class that uses comma as decimal separator: NumberFormat.getNumberInstance(Locale.FRANCE).parse(“265,858”) This results in 265.858. But using US locale you’ll get 265858: NumberFormat.getNumberInstance(java.util.Locale.US).parse(“265,858”) That’s because in France they treat comma as decimal separator while in US – … Read more

Decimal separator in NumberFormat

by

The helper class DecimalFomatSymbols is what you are looking for: DecimalFormat format = (DecimalFormat) DecimalFormat.getInstance(); DecimalFormatSymbols symbols = format.getDecimalFormatSymbols(); char sep=symbols.getDecimalSeparator(); To set you symbols as needed: //create a new instance DecimalFormatSymbols custom=new DecimalFormatSymbols(); custom.setDecimalSeparator(‘,’); format.setDecimalFormatSymbols(custom); EDIT: this answer is only valid for DecimalFormat, and not for NumberFormat as required in the question. Anyway, as … Read more

Problem parsing currency text to decimal type

by

How about using: decimal d = decimal.Parse(“$45.00”, NumberStyles.Currency); The MSDN documentation on Decimal.Parse states: “The s parameter is interpreted using the NumberStyles.Number style. This means that white space and thousands separators are allowed but currency symbols are not. To explicitly define the elements (such as currency symbols, thousands separators, and white space) that can be … Read more

JavaScript Chart.js – Custom data formatting to display on tooltip

by

For chart.js 2.0+, this has changed (no more tooltipTemplate/multiTooltipTemplate). For those that just want to access the current, unformatted value and start tweaking it, the default tooltip is the same as: options: { tooltips: { callbacks: { label: function(tooltipItem, data) { return tooltipItem.yLabel; } } } } I.e., you can return modifications to tooltipItem.yLabel, which … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)