Javascript extracting number from string

Question

I have a bunch of strings extracted from html using jQuery.

They look like this:

var productBeforePrice = "DKK 399,95";
var productCurrentPrice = "DKK 299,95";

I need to extract the number values in order to calculate the price difference.

(So I wend up with ≈

var productPriceDiff = DKK 100";

or just:

var productPriceDiff = 100";)

Can anyone help me do this?

Thanks, Jakob

Are your numbers always going to be in a similar format? You can use a regular expression to grab just the number part then create a new Number() with the string. — Kekoa
– Kekoa, Commented Jun 12, 2009 at 15:46

Patrick McElhaney · Accepted Answer · 2012-09-27 12:55:54Z

10

First you need to convert the input prices from strings to numbers. Then subtract. And you'll have to convert the result back to "DKK ###,##" format. These two functions should help.

var priceAsFloat = function (price) {  
   return parseFloat(price.replace(/\./g, '').replace(/,/g,'.').replace(/[^\d\.]/g,''));
}

var formatPrice = function (price) {  
   return 'DKK ' + price.toString().replace(/\./g,',');
}

Then you can do this:

var productBeforePrice = "DKK 399,95"; 
var productCurrentPrice = "DKK 299,95";
productPriceDiff = formatPrice(priceAsFloat(productBeforePrice) - priceAsFloat(productCurrentPrice));

edited Sep 27, 2012 at 12:55

answered Jun 12, 2009 at 16:04

Patrick McElhaney

59.6k41 gold badges138 silver badges170 bronze badges

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

2 Comments

Jakob Madsen Over a year ago

Just realized it doesn't work with larger prices like "DKK 1.299,95".

Patrick McElhaney Over a year ago

Okay, I fixed it to work with larger prices by stripping all of the periods before doing anything else. I didn't fix the formatPrice function. It will return a valid price, but without the periods ("DKK 1299,95"). If you need help doing that, ask another question. :-)

Jonathan Fingland · Accepted Answer · 2009-06-12 15:47:22Z

5

try:

var productCurrentPrice = productBeforePrice.replace(/[^\d.,]+/,'');

edit: this will get the price including numbers, commas, and periods. it does not verify that the number format is correct or that the numbers, periods, etc are contiguous. If you can be more precise in the exact number definitions you expcet, it would help.

answered Jun 12, 2009 at 15:47

Jonathan Fingland

57.3k11 gold badges89 silver badges79 bronze badges

2 Comments

brettkelly Over a year ago

Pretty sure that you need to escape that period, actually.

Jonathan Fingland Over a year ago

pretty sure you don't. it's inside the []. outside of that and it would need escaping. just tested in firefox and it's working as expected

Keeper · Accepted Answer · 2009-06-12 15:51:48Z

2

try also:

var productCurrentPrice = productBeforePrice.match(/\d+(,\d+)?/)[0];

answered Jun 12, 2009 at 15:51

Keeper

3,5661 gold badge20 silver badges29 bronze badges

Comments

brettkelly · Accepted Answer · 2009-06-12 15:58:08Z

1

var productCurrentPrice = parseInt(productBeforePrice.replace(/[^\d\.]+/,''));

That should make productCurrentPrice the actual number you're after (if I understand your question correctly).

answered Jun 12, 2009 at 15:58

brettkelly

28.3k8 gold badges58 silver badges73 bronze badges

1 Comment

Jonathan Fingland Over a year ago

fails on commas as provided in his example of number format for danish kroners.

Collectives™ on Stack Overflow

Javascript extracting number from string

4 Answers 4

2 Comments

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related