Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Regex greater than zero with 2 decimal places

Tags:

regex

decimal

I need a RegEx for a numeric value with up to two decimal places greater than zero and may or may not have a zero in the ones column. I should also add....whole numbers are fine. See somments below but there could be leading or trailing white spaces

Good values:
.1
0.1
1.12
123.12
92
092
092.13

Error values:
0
0.0
0.00
00
1.234
-1
-1.2
Anything less than zero
like image 462
MikeTWebb Avatar asked Dec 22 '11 21:12

MikeTWebb


3 Answers

How about this:

^\s*(?=.*[1-9])\d*(?:\.\d{1,2})?\s*$

Explanation:

^            # Start of string
\s*          # Optional whitespace
(?=.*[1-9])  # Assert that at least one digit > 0 is present in the string
\d*          # integer part (optional)
(?:          # decimal part:
 \.          # dot
 \d{1,2}     # plus one or two decimal digits
)?           # (optional)
\s*          # Optional whitespace
$            # End of string

Test in Python:

>>> import re
>>> test = [".1", "0.1", "1.12", "123.12", "92", "092", "092.13", "0", "0.0", "0.00", "00", "1.234", "-1", "-1.2"]
>>> r = re.compile(r"^\s*(?=.*[1-9])\d*(?:\.\d{1,2})?\s*$")
>>> for item in test:
...     print(item, "matches" if r.match(item) else "doesn't match")
...
.1 matches
0.1 matches
1.12 matches
123.12 matches
92 matches
092 matches
092.13 matches
0 doesn't match
0.0 doesn't match
0.00 doesn't match
00 doesn't match
1.234 doesn't match
-1 doesn't match
-1.2 doesn't match
like image 69
Tim Pietzcker Avatar answered Oct 31 '22 15:10

Tim Pietzcker


The code below allows both , and ..

^(?=.*[1-9])[0-9]*[.,]?[0-9]{1,2}$
like image 4
Sergejs Cukanovs Avatar answered Oct 31 '22 13:10

Sergejs Cukanovs


/^[0-9]*(\.{1})?([0-91-9][1-9])?$/

try this it passes all your cases

like image 1
bharath muppa Avatar answered Oct 31 '22 13:10

bharath muppa