how to validate for money in jquery

Question

how to validate for money in jquery where max amount i can enter is 9999.99 so my requirements are: 1.it should allow only digits and one dot 2.max length is 7(including dot) 3.before dot max length is 4 4.after dot max length is 2

currently my textbox allows only digits and one dot with the following code

$('#txtpaymentamnt, #txttenderamt').on("keypress", function (e) {
    alert(e.which);
    if (e.which != 8 && e.which != 0 && ((e.which < 48 || e.which > 57) && e.which != 46)) {
        e.preventDefault();
    }

Do you need to check input value on event (for example, button click) or prevent entering wrong data ? — siniy, Jan 09 '14 at 10:56
text box leave event or prevent entering wrong data(but should pop up a message saying max amnt is 9999.99) — Santosh, Jan 09 '14 at 11:02
If you are using html5 u can have and use the min and max properties — Nitin Varpe, Jan 09 '14 at 11:11
Please only use the [tag:jquery-validate] tag when using the jQuery Validation plugin. Edited. — Sparky, Jan 09 '14 at 17:36

James Hibbard · Accepted Answer · 2014-01-09T11:57:39.920

19

You can do this with a regular expression: /^\d{0,4}(\.\d{0,2})?$/

EDIT:

Here's the requested fiddle

edited Jan 09 '14 at 11:57

answered Jan 09 '14 at 10:50

James Hibbard

16,490
14
62
74

I updated the regular expression and added a fiddle. – James Hibbard Jan 09 '14 at 11:58
thanks Jack Zelig ...it worked for me,but need to change for not accepting alphabets – Santosh Jan 09 '14 at 15:08
It tries to match zero to four digits, an optional decimal point followed by zero to two digits. Letters won't match and will be rejected. Or did you mean something else? – James Hibbard Jan 09 '14 at 15:19
hey it works now JackZelig...I guess i missed something..thanks much :) – Santosh Jan 09 '14 at 15:40
The fiddle removes the last character even if that wasn't the character your entered incorrectly. I've updated to improve on this, but it's still not perfect. http://jsfiddle.net/vY39r/171/ – DeadPassive Aug 15 '14 at 07:09
3

@DeadPassive the jsfiddle you provided put undefined in the input box if the first character inputted isn't valid. I fixed it in this fiddle: http://jsfiddle.net/w0jekdL6/ – Brian Jenkins Apr 24 '15 at 17:13
1

freakin awesome example, does exactly what I needed. – Cesar Bielich Jul 04 '15 at 02:22
how can set not allow input dot (.) character – dungphanxuan Mar 31 '17 at 03:19
Just remove it from the regex: `/^\d{0,4}(\d{0,2})?$/` – James Hibbard Apr 02 '17 at 11:52
your solution is well suited to me, but when I check against input type number it didn't work. Couldn't fix the issue... – pTi Jun 23 '17 at 03:16
That's a shame. If you can fit your code into a comment, let me know and I'll have a look. Otherwise, maybe post a new question. – James Hibbard Jun 23 '17 at 08:21

Moni · Answer 2 · 2014-01-09T15:20:17.623

11

With jQuery validation plugin you can set your own rule using Jack's regular expression (which I haven't tested though) like this:

jQuery.validator.addMethod(
    "money",
    function(value, element) {
        var isValidMoney = /^\d{0,4}(\.\d{0,2})?$/.test(value);
        return this.optional(element) || isValidMoney;
    },
    "Insert "
);

Then you can set the rule within using the validate method:

$("#myForm").validate({
rules: {
    nameOfMyInputField: {
        money: true,
    }
}
});

edited Jan 09 '14 at 15:20

answered Jan 09 '14 at 12:40

Moni

189
1
9

I updated the regular expression which has been updated by Jack Zelig in his post. – Moni Jan 09 '14 at 15:21

score 0 · Answer 3 · edited May 23 '17 at 12:34

If I were you, I'd use the isNumeric function in this answer to check if the input is a number and then check if the number is valid for your case.

To ve a "valid number" (according to your requirements), it has to:

Be between 0 and 9999.99 (maximum of 4 digits before the dot).
Have a maximum of 2 decimal digits. A good way to check that is to truncate the number after the nth digit (in your case, the second one) and compare it to the original value(two different values mean the second number has more decimal digits than the first). Use Math.round(number*100)/100 to truncate everything after the second decimal digit.

I hope this helps you with your problems.

score 0 · Answer 4 · answered Jan 09 '14 at 12:45

As you said, if you are using MVC. MVC framework provides annotations which can be used to best effects. Even if there is no explicit data annotation for a decimal.

Following can be used for Two Decimal places

[RegularExpression(@"^\d+.\d{0,2}$")]

And for range you can use

[Range(0, 9999.99)]

So your model field becomes

[RegularExpression(@"^\d+.\d{0,2}$")]
[Range(0, 9999.99)]
public decimal Money{ get; set; }

Hope It Helps

how to validate for money in jquery

4 Answers4

Linked

Related