Culture sensitive ParseFloat Function in JavaScript?

Question

Do anyone have suggestion for writing culture sensitive ParseFloat Function in JavaScript, So that when I have a string 100,000.22 in US culture format the parse float function returns 100000.22 whereas if I enter 100.000,22 in Swedish Culture it returns 100000.22 in float?

As I was writing solution for ASP.Net application, I managed to solve my problem without writing any custom solution for it. As MSDN library provide the JavaScript Base Type Extensions method, one of which is Number Type Extensions which has functions localeFormat, and parseLocale. These function provides the conversion from/to decimal format w.r.t culture. see this like http://msdn.microsoft.com/en-us/library/bb310835(v=VS.90).aspx. — Faheem Ramzan, Feb 10 '11 at 22:26
Also one can set the culture from the server otherwise these functions will use the default culture. see this link http://msdn.microsoft.com/en-us/library/bz9tc508(v=VS.90).aspx. In my case I have to set sv-SE, because I need to use the Swedish culture for formating the numbers. — Faheem Ramzan, Feb 10 '11 at 22:31
Possible duplicate of [How do I convert String to Number according to locale (opposite of .toLocaleString)?](https://stackoverflow.com/questions/25645163/how-do-i-convert-string-to-number-according-to-locale-opposite-of-tolocalestri) — Nickolay, Nov 07 '17 at 01:32

score 6 · Answer 1 · edited Mar 11 '14 at 19:51

6

I've improved mwilcox' function to handle values withous separators.

function parseFloatOpts (str) {

     if(typeof str === "number"){
         return str;
     }

     var ar = str.split(/\.|,/);  

     var value = '';
     for (var i in ar) {
         if (i>0 && i==ar.length-1) {
             value += ".";
         }
         value +=ar[i];
     }
     return Number(value);
}

edited Mar 11 '14 at 19:51

Willem Van Onsem

443,496
30
428
555

answered Nov 29 '12 at 14:43

Alex Polishchuk

99
1
4

score 3 · Answer 2 · answered Feb 09 '11 at 23:36

This is a bit rough-and-ready, but it may be sufficient, allowing you to pass in the thousands and decimal separators:

function parseFloatOpts(num, decimal, thousands) {
    var bits = num.split(decimal, 2),
        ones = bits[0].replace(new RegExp('\\' + thousands, 'g'), '');
        ones = parseFloat(ones, 10),
        decimal = parseFloat('0.' + bits[1], 10);
        return ones + decimal;
}

Examples:

parseFloatOpts("100.000,22", ',', '.'); //100000.22
parseFloatOpts("100,000.22", '.', ','); //100000.22

NB that this doesn't ensure that the thousands separator really does represent thousands, etc., or do lots of other safeguarding that you may wish to do, depending on the importance of the function.

Thanks for your reply, I am able to solve the problem in ASP.Net. See my above reply in my original post. — Faheem Ramzan, Feb 10 '11 at 22:33

score 1 · Answer 3 · answered Feb 09 '11 at 23:39

var parse = function(st){
   if(st.indexOf(",") === st.length-3){
      st = st.replace(".", "").replace(",", ".");
   }else{
       st = st.replace(",", "");
   }
   return parseFloat(st, 10)
}

console.log(parse("100,000.22")) // 100000.22
console.log(parse("100.000,22")) // 100000.22

I'm just checking if there is a comma in the 3rd-to-last position. This could be further refined to check if there is a period in the 4th to last position in the case thee is no comma (such as 100.000)

score 1 · Answer 4 · answered Feb 09 '11 at 23:44

1

Looking at lonesomday's gave me this thought:

You could also do:

function parse (str)
    var ar = str.split(/\.|,/);  
    return Number(ar[0]+ar[1]+"."+ar[3]);

answered Feb 09 '11 at 23:44

mwilcox

4,065
23
20

How's that going to work for variable numbers of thousands separators? – lonesomeday Feb 09 '11 at 23:49

score 1 · Answer 5 · answered Feb 09 '11 at 23:59

Here is a rough function. It will assume the last punctuation to indicate decimals, whether it is a comma, period, or any other character you may need to indicate. It then eliminates other punctuations from the whole number. Puts it back together and parses as float.

function normalizeFloat(number, chars) {

    var lastIndex = -1;
    for(i=0; i < chars.length; i++) {
        t = number.lastIndexOf(chars[i]);

        if (t > lastIndex) {
            lastIndex = t;
        }
    }

    if (lastIndex == -1) {
        lastIndex = number.length;
    }

    var whole = number.substring(0, lastIndex);   
    var precision = number.substring(lastIndex);
    for (i=0; i < chars.length; i++) {
        whole = whole.replace(chars[i], '');
        precision = precision.replace(chars[i],'.');           
    }
    number = whole + precision;

    f = parseFloat(number);
    return f;
}

try this:

alert(normalizeFloat('12.345,77', [',','.']).toFixed(2));
alert(normalizeFloat('12,345.77', [',','.']).toFixed(2));

score 0 · Answer 6 · answered Sep 05 '19 at 06:07

Need your current Group and Decimal Separator from Culture Info.

function escapeRegExp(string) {
        return string.replace(/[.*+?^${}()|[\]\\]/g, "\\$&");
    }

function parseFloatOpts(str, groupSeparator, decimalSeparator) {

        if (typeof str === "number") {
            return str;
        }

        var value = str.replace(new RegExp(escapeRegExp(groupSeparator), 'g'), "");
        value = value.replace(decimalSeparator, ".");

        return Number(value);
    }

score 0 · Answer 7 · answered Feb 19 '20 at 11:29

If you really for displaying and/or parsing floats (or dates or currencies or more) in different locales for JavaScript, then my recommendation is the GlobalizeJS (https://github.com/globalizejs/globalize) library.

It's a bit tough to set up at first (at least it was in my experience), but totally recommended for proper management of this matter.

Culture sensitive ParseFloat Function in JavaScript?

7 Answers7

Linked

Related