I have found a regex on stackoverflow to add a ',' or '.' after every third number depending on your language.
(\d)(?=(\d\d\d)+(?!\d))
The problem is that it also happens when we reach the decimal point like with for example:
5487445.46878
The result of that with the following code (and regex) is:
return number.replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,");
Which results in:
5,487,445.46,878
I'm using this regex when I'm converting a number depending on your language. In Dutch for example a comma is used as a seperator, so there I do the following:
return number.replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1.")
Which results in
5.487.445,46.878
These of course need to become:
5,487,445.46878
and
5.487.445,4687
Does anybody know where I need to update the regex to ignore the decimal point?
You can use your RegEx but split your number first if its has a comma or point in it.
var input = '5487445.46878';
var parts = input.split('.');
var part1 = parts[0].replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,");
var part2 = parts[1];
alert(part1 + '.' + part2);
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments