javascript regex to validate decimal datatype

Question

I need to validate the decimal datatype in the incoming feed. Integer part and the fraction value combined together can have up to 7 chars. Fraction value is optional. Leading + or - is also optional.

For example DECIMAL(7, 2) defines numbers of the form 12345.67

test case

Valid
-1
+1
1
+.1
-.1
.1
+11111.11
-11111.11
11.11
11111

Invalid
1111111
11.11111
0.111111
.1111111
+111111.11
-111111.11
+11111.111
-11111.111
11111.111
111111.11
+1.
-1.
1.

This is what I currently use

[+-]?\d\.?\d?

How should I change this?

anubhava · Accepted Answer · 2017-01-17 05:00:51Z

5

You can use this regex:

/^[+-]?\d{0,5}(?:\.\d{1,2})?$/gm

RegEx Demo

edited Jan 17, 2017 at 5:00

answered Jan 17, 2017 at 4:35

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

4 Comments

anubhava Over a year ago

I've added explanation of lookahead used in answer.

Srini V Over a year ago

Sorry @anubhava I made a blunder. I have edited the test cases.

Srini V Over a year ago

DECIMAL(7, 2) defines numbers of the form 12345.67, so the fraction part is given 2 chars and the rest 5 chars go to integer.

Srini V Over a year ago

Cool, so (?=(?:\D*\d){1,7}$) has any relevance in the new snippet, I feel it is redundant.

Collectives™ on Stack Overflow

javascript regex to validate decimal datatype

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related