Regex Currency format - javascript

Question

I'm currently using the following regex to validate currency in my html input form fields:

/[1-9]\d*(?:\.\d{0,2})?/

Howevever, it is allowing the following value through: 13000.234.12

This is not a valid value. Here are valid values that I want to allow through:

VALID

INVALID

130.1.4
21.......14

It feels like there should be a standard regex pattern out there for this, thoughts?

Side note: I'm preventing alphanumeric characters and dollar signs via the event key listener, so they already will not be able to be entered, which should make this problem a little easier.

If you're using a regular expression to validate the input, there is no need for a key event listener. You only need to validate the input when the user has finished entering characters, until then you really don't care what the value is (e.g. the user may copy and paste from elsewhere, then edit what they pasted). — RobG
– RobG, Commented Aug 14, 2012 at 3:45

Blender · Accepted Answer · 2012-08-14 03:37:04Z

12

Something like this should work:

^(\d*\.\d{1,2}|\d+)$

It matches:

1.00
1
0.23
0.2
.2

It doesn't match:

.
1.1.

answered Aug 14, 2012 at 3:37

Blender

300k55 gold badges462 silver badges511 bronze badges

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

2 Comments

jfriend00 Over a year ago

Don't you need ^ and $ to make sure there isn't junk on the ends?

JohnH Over a year ago

Use "d{0,2}" to allow values like "1.".

Gareth Parker · Accepted Answer · 2012-08-14 03:38:41Z

1

/^(\d*?)(\.\d{1,2})?$/

So it's (Start) (Any amount of numbers only, even zero), (. and then numbers only, one or two, doesn't HAVE to be there though) End

answered Aug 14, 2012 at 3:38

Gareth Parker

5,0832 gold badges22 silver badges43 bronze badges

4 Comments

Blender Over a year ago

Wouldn't this match an empty string as well?

Gareth Parker Over a year ago

It would, but it also allows more common entries like .25, or 1.2, rather than forcing 0. at the beginning. Do you have any suggestions on how I could force a minimum character limit while keeping the flexibility?

Blender Over a year ago

You basically have two patterns (1.0 and .0) to worry about, so I had to break the regex down into essentially two separate regex patterns separated by an |.

Gareth Parker Over a year ago

Ah, I see, that is a rather good way to do it. I hadn't thought of that. I need to brush up on my regex more often

Rizier123 · Accepted Answer · 2015-02-14 19:09:52Z

1

I used the comma for decimal separator. Here my friends:

^([0]?(,\d{1,2})?|([1-9]{1,3})?((\.\d{3})*|([1-9])*)?(,\d{1,2})?)?$

edited Feb 14, 2015 at 19:09

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

answered Feb 14, 2015 at 18:52

Mattia Peterle

313 bronze badges

Collectives™ on Stack Overflow

Regex Currency format - javascript

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related