regex for money values in JavaScript

Question

Been out of the regex game for a while. Trying to come up with something that will allow the user to enter a money value either with/without dollar sign or with/without commas. For example, all the of the following values should be valid:

5
5.1
5.10
$5
500,000
500,000.1
500,000.10
$100,000,000.50
etc....

Could someone please help me out?

Try this site. regexlib.com/Search.aspx?k=money

Larry Battle
– Larry Battle

2012-08-03 16:23:23 +00:00
Commented Aug 3, 2012 at 16:23 — Larry Battle
– Larry Battle, Commented Aug 3, 2012 at 16:23

Kip · Accepted Answer · 2012-08-03 16:29:55Z

23

This should work:

isValid = str.search(/^\$?[\d,]+(\.\d*)?$/) >= 0;

A little more strict with comma placement (would reject 3,2.10, for example):

isValid = str.search(/^\$?\d+(,\d{3})*(\.\d*)?$/) >= 0;

To get a number out of it:

if(isValid) {
  var num = Number(str.replace(/[\$,]/g, ''));
  ...
}

edited Aug 3, 2012 at 16:29

answered Aug 3, 2012 at 16:24

Kip

110k87 gold badges243 silver badges268 bronze badges

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

9 Comments

Bergi Over a year ago

Instead of string.search(regex)>-1, just use regex.test(string)

heymatthew Over a year ago

Error in your first regex. Regex evaluates "10." as true. Use + instead of * to mean 'at least 1'. Try isValid = str.search(/^\$?[\d,]+(\.\d+)?$/) >= 0;

Kip Over a year ago

@MatthewB.Gray that's not an error. I would consider "10." to be valid. The question does not specify one way or the other.

Tango Bloom Over a year ago

Quick note I noticed when testing this, I would change the (\.\d*)? to be (\.\d{2})? since cents pretty much always goes to hundredths and no further. Also the first \d+ could be \d{1,3}, so it doesn't just match all numbers before a comma.

Kip Over a year ago

@Zorpix thanks for the input. the \d+ was also to allow numbers with no comma at all, which is how most people actually type them. if you want to be even more strict about comma placement, without actually requiring commas, you could use (\d+|\d{1,3}(,\d{3})*). This regex also doesn't accept decimal-only numbers, like .01

|

Larry Battle · Accepted Answer · 2012-08-03 16:42:08Z

I didn't Test Driven Developement, TDD, for this one using the Qunit framework.

TDD overview http://net.tutsplus.com/tutorials/javascript-ajax/test-driven-javascript-development-in-practice/

1st: Write tests.

2nd: Watch tests fail.

3rd: Make test pass.

4th: Refactor.

var moneyTest_RE = /^\$?\d+((,\d{3})+)?(\.\d+)?$/;
test("test money format for valid values", function () {
    var moneyArr = ["5","5.1","5.10","$5","500,000","500,000.1","500,000.10","$100,000,000.50", "500,000,100" ];
    var i = moneyArr.length;

    while( i-- ){
        equal( moneyTest_RE.test( moneyArr[ i ] ), true, moneyArr[ i ] + " didn't match completely." );
    }
});
test("test money format for invalid values", function () {
    var moneyArr = ["5..","$$5.1",".5.10","$5.2.","50,0,000",",500,000.1","500,000,10,","$1,00,000,000.50", "500,000,10"];
    var i = moneyArr.length;

    while( i-- ){
        equal( moneyTest_RE.test( moneyArr[ i ] ), false, moneyArr[ i ] + " didn't match completely." );
    }
});

Here's one possible solution to your problem.

var moneyTest_RE = /^\$?\d+((,\d{3})+)?(\.\d+)?$/;

Demo here: http://jsfiddle.net/vpyV6/

I forgot to refactor though.

Tango Bloom · Accepted Answer · 2015-08-06 21:12:35Z

2

^(\$?\d{1,3}(?:,?\d{3})*(?:\.\d{2})?|\.\d{2})?$

This one took a while, but I finally got something fully functional. It allows for cases such as 100.00, .35, $1.35, etc. While excluding entries with misplaced commas, too many numbers in between or before commas, or too many numbers after the decimal point.

You can play around with it here

edited Aug 6, 2015 at 21:12

answered Jun 9, 2014 at 15:18

Tango Bloom

3,5145 gold badges22 silver badges35 bronze badges

Comments

Himanshu Teotia · Accepted Answer · 2018-06-30 05:04:35Z

0

var currencyRegex = /^[$£€]\d+(?:\.\d\d)*$/g;

Example: $10 or £10 0r €10 but if you use simple 10 this will be wrong

answered Jun 30, 2018 at 5:04

Himanshu Teotia

2,1851 gold badge31 silver badges41 bronze badges

Comments

trincot · Accepted Answer · 2023-05-02 14:59:18Z

0

Perhaps this? https://regex101.com/r/xBct9E/1

(\$?(:?\d+,?.?)+)

Also, https://regex101.com/r/xBct9E/3 ; a longer version that doesn't match numbers like 123,45.4.3

^(\$?(:?\d+,?)+(?:.?\d+)?)$

edited May 2, 2023 at 14:59

trincot

357k38 gold badges282 silver badges338 bronze badges

answered Aug 3, 2012 at 16:26

user1034533

1,0849 silver badges9 bronze badges

3 Comments

user1034533 Over a year ago

what more do you want me to post?

Bergi Over a year ago

Thanks, what you added in the edit shortly after my comment from 2012 was enough - I'm deleting the no longer applicable comment. I didn't downvote, that happened somewhen last December. Maybe your answer was downvoted because it doesn't use JS regex literal syntax, or because it allows : characters, or because it allows .s to immediately follow ,s?

user1034533 Over a year ago

ah, not devoted enough to fix the dots and commas thing, but the : thing was a bug which is now fixed!

Constantin De La Roche · Accepted Answer · 2023-12-11 17:12:15Z

0

To handle most of inputs (including cases with ,):

const inputValue = '1,999.50'
const inputValueNoSpace = inputValue.replace(/\s+/igm, '')
const inputValueEnglish = inputValueNoSpace.replace(/(^[0-9,]*),(\d{1,2}$)/igm, "$1.$2").replace(',', '')

> inputValueEnglish
← '1999.50'

answered Dec 11, 2023 at 17:12

Constantin De La Roche

3,45029 silver badges29 bronze badges

Collectives™ on Stack Overflow

regex for money values in JavaScript

6 Answers 6

9 Comments

Comments

Comments

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

9 Comments

Comments

Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related