Javascript, regex, keep numerical part from string, including decimal place

Question

I need to parse some data that contains comma formatted numbers and text like this, keeping only numerical part:

"The stock is 1,124 units"

I came up with this regex that is working great, except for numbers under 0, example a price that could be 0,259 EUR

qty = qty.textContent.replace(/\D/g,'');

How can I modify for removing only text, but still keeping the sense of original number

I'd like -> 0.259 Not -> 0259

EDITED

I need both situations, thousands separator and decimal place.

Depending on parse, could be USD when comma is thousands separator, or EUR, where dot is decimal place. I will make a switch case for currency and thank you for your fast answers!

Ok, so that comma is a thousands separator and not a decimal separator, right? Is there any other punctuation in the original string? — Matt Burland
– Matt Burland, Commented May 31, 2017 at 20:15

Matt Burland · Accepted Answer · 2017-05-31 20:27:16Z

2

So long as there are no periods in the string overwise, then this should work:

qty = qty.textContent.replace(/[^\d\.]/g,'');

If there is (or might be) other periods, then it gets a little more tricky.

You might try something like:

([^\d.]|\.(?!\d))

This will match characters that aren't numeric digits or periods, or periods that aren't followed by another digit. So something like this should work:

"The st.oc.k is 1,124.22 units.".replace(/([^\d.]|\.(?!\d))/g,"")

Gives you back: 1124.22

edited May 31, 2017 at 20:27

answered May 31, 2017 at 20:16

Matt Burland

45.3k18 gold badges110 silver badges182 bronze badges

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

1 Comment

user1797147 Over a year ago

I accepted yours because it's working, however, I use /[^\d\.,]/g then replace comma if USD. Thank you Matt!

Quartal · Accepted Answer · 2017-05-31 20:19:37Z

2

This regex should work

\d+(\,|\.)\d+

It matches both 1,230 and 0.123

If you want to remove the comma you can do this

yourstr.replace(",", "");

edited May 31, 2017 at 20:19

answered May 31, 2017 at 20:15

Quartal

4103 silver badges14 bronze badges

2 Comments

Matt Burland Over a year ago

I believe the original intent was to remove the comma. Although the question isn't exactly clear, but that's what the OP's original does.

user1797147 Over a year ago

I need both, sorry for confusion

Collectives™ on Stack Overflow

Javascript, regex, keep numerical part from string, including decimal place

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related