Best way to remove thousand separators from string amount using a regex

Question

I have variables that contain amounts and would like to remove the (US) thousand separators but also have to cover the scenario that there may be non-US formatted amounts where the comma is used for the decimals instead of for the thousands where I don't want to replace the comma.

Examples:

1,234,567.00 needs to become 1234567.00
1,234.00 needs to become 1234.00
but
1.234.567,00 needs to remain unchanged as not US format (i.e. comma here is used for decimals)
1.234,00 needs to remain unchanged as not US format (i.e. comma here is used for decimals)

I was thinking of using the following but wasn't sure about it as I am pretty new to Regex:

myVar.replace(/(\d+),(?=\d{3}(\D|$))/g, "$1");

What is best solution here? Note: I just need to cover normal amounts like the above examples, no special cases like letter / number combinations or things like 1,2,3 etc.

Will you always have 2 decimals? If not, then you will never know whether 1,234 is 1000 + 234 or 1 + 0.234 — tomdemuyt, Nov 24 '14 at 13:17

score 12 · Accepted Answer · answered Nov 24 '14 at 13:28

12

This one may suit your needs:

,(?=[\d,]*\.\d{2}\b)

Regular expression visualization

Debuggex Demo

answered Nov 24 '14 at 13:28

sp00m

47,968
31
142
252

Thanks for this - wouldnt I need to wrap this in / /g to cover all instances of thousand separators ? – user2571510 Nov 24 '14 at 13:36
thank you for the Debuggex Demo web site, never seen it before really great one the with the graph. – albanx Nov 24 '14 at 13:37
1

@user2571510 Yes, you'll have to enable the `global` flag: `/theregex/g`. – sp00m Nov 24 '14 at 13:39
Thanks, All - this works very well and I like the workflow image. – user2571510 Nov 24 '14 at 13:46

hon2a · Answer 2 · 2014-11-24T13:41:10.753

5

if (string.match(/\.\d{2}$/) {
    string = string.replace(',', '');
}

or

string.replace(/,(?=.*\.\d+)/g, '');

edited Nov 24 '14 at 13:41

answered Nov 24 '14 at 13:31

hon2a

7,006
5
41
55

Thanks - I would like to avoid using IF statements here. – user2571510 Nov 24 '14 at 13:37

score 4 · Answer 3 · answered May 23 '20 at 15:36

4

You can use replace() method to remove all the commas. They will be replaced with an empty string. I'm using reg exp with lookahead assertion to detect if a comma is followed by three digits, if so given comma will be removed.

string.replace(/,(?=\d{3})/g, '')

Examples:

'12,345,678.90'.replace(/,(?=\d{3})/g, '')
// '12345678.90'

'1,23,456.78'.replace(/,(?=\d{3})/g, '')
// '1,23456.78'

'$1,234.56'.replace(/,(?=\d{3})/g, '')
// '$1234.56'

answered May 23 '20 at 15:36

user3812733

165
1
9

This answer worked for me – Mehdi Faraji Nov 14 '21 at 18:03
This works until you have Argentine Peso ARS '1.222,222'.replace(/,(?=\d{3})/g, '') evaluates to '1.222222' – eomeroff Apr 04 '22 at 21:07

score 2 · Answer 4 · answered Nov 24 '14 at 13:24

2

Replace /,(?=\d*[\.,])/g with empty string?

http://regexr.com/39v2m

answered Nov 24 '14 at 13:24

Sam Greenhalgh

5,952
21
37

Thanks for this as well ! I am trying to understand what makes the most sense here for me. – user2571510 Nov 24 '14 at 13:37

score 1 · Answer 5 · answered Dec 05 '22 at 12:45

1

This code is worked for me and you can use it in set amount val for remove separators

t.replace(/,(?=\d{3})/g, '')

answered Dec 05 '22 at 12:45

Iman Radmanesh EPRE.ir

11
1

JohnP2 · Answer 6 · 2015-12-05T01:49:04.770

0

myVar = myVar.replace(/([.,])(\d\d\d\D|\d\d\d$)/g,'$2');

Removes the period . or comma , when used as a thousand separator.

edited Dec 05 '15 at 01:49

answered Dec 05 '15 at 00:43

JohnP2

1,899
19
17

How to do this in sql query analyzer using Find/Replace and regex – Partha Mandayam May 29 '23 at 15:37

Best way to remove thousand separators from string amount using a regex

6 Answers6

Linked

Related