How to parse number with points and commas

Question

I recieve an string like;

1.234.567,89

I want 1234567.89

Comma is decimal delimiter.Point is thousands, and millions delimiter

I want to treat as a number.

I try replaces, but only works with first ".". And parseFloat. Also I try some regex that found here,but doesn't work for me

I want this;

    var numberAsString= '1.234.567,89';
    //Step to clean string and conver to a number to compare (numberAsString => numberCleaned)
    if (numberCleaned> 1000000) {alert("greater than 1 million");}

Any Idea? (Sorry if its a newbie question, but I dont found any solution in hours...)

Remove all the . characters, replace , with ., and then call parseFloat(). — Barmar
– Barmar, Commented May 5, 2020 at 15:01
While asking a question post all the code attempts that you have made. Please read through the help center, in particular How do I ask a good question? — palaѕн
– palaѕн, Commented May 5, 2020 at 15:05

brk · Accepted Answer · 2020-05-05 15:04:50Z

5

You can use replace with g

const val = '1.234.567,89'.replace(/\./gi, '').replace(/,/, '.');
console.log(val)
console.log(typeof parseFloat(val))

answered May 5, 2020 at 15:04

brk

50.3k10 gold badges59 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

josemb94 Over a year ago

It works perfect!! I chose you as solution! thanks!

anees · Accepted Answer · 2020-05-05 15:06:31Z

1

this should work for the current scenario. 1st remove the dots then replace the comma with dot.

let number = "1.234.567,89";

function parseNum(num){
    return num.replace(/\./g, '').replace(",", ".")
}


console.log(parseNum(number));

answered May 5, 2020 at 15:06

anees

1,8853 gold badges20 silver badges27 bronze badges

3 Comments

Argee Over a year ago

or Number.parseFloat('1.234.567,89'.split('.').join('').replace(',','.')) but yours is nicer :D

anees Over a year ago

@Argee well there are obviously a lot of methods to achieve it but the better solution will be easy to understand and re implement.

josemb94 Over a year ago

Also try this soloution, and works fine, nice for getting more ideas!

Collectives™ on Stack Overflow

How to parse number with points and commas

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related