Trish
Trish

Reputation: 1875

Decimal number regular expression, where digit after decimal is optional

I need a regular expression that validates a number, but doesn't require a digit after the decimal. ie.

123
123.
123.4

would all be valid

123..

would be invalid

Any would be greatly appreciated!

Upvotes: 185

Views: 527535

Answers (18)

pndc
pndc

Reputation: 3795

In Perl, use Regexp::Common which will allow you to assemble a finely-tuned regular expression for your particular number format. If you are not using Perl, the generated regular expression can still typically be used by other languages.

Printing the result of generating the example regular expressions in Regexp::Common::Number:

$ perl -MRegexp::Common=number -E 'say $RE{num}{int}'
(?:(?:[-+]?)(?:[0123456789]+))

$ perl -MRegexp::Common=number -E 'say $RE{num}{real}'
(?:(?i)(?:[-+]?)(?:(?=[.]?[0123456789])(?:[0123456789]*)(?:(?:[.])(?:[0123456789]{0,}))?)(?:(?:[E])(?:(?:[-+]?)(?:[0123456789]+))|))

$ perl -MRegexp::Common=number -E 'say $RE{num}{real}{-base=>16}'
(?:(?i)(?:[-+]?)(?:(?=[.]?[0123456789ABCDEF])(?:[0123456789ABCDEF]*)(?:(?:[.])(?:[0123456789ABCDEF]{0,}))?)(?:(?:[G])(?:(?:[-+]?)(?:[0123456789ABCDEF]+))|))

Upvotes: 0

railgun
railgun

Reputation: 1021

^[+-]?(([1-9][0-9]*)?[0-9](\.[0-9]*)?|\.[0-9]+)$

should reflect what people usually think of as a well formed decimal number.

The digits before the decimal point can be either a single digit, in which case it can be from 0 to 9, or more than one digits, in which case it cannot start with a 0.

If there are any digits present before the decimal sign, then the decimal and the digits following it are optional. Otherwise, a decimal has to be present followed by at least one digit. Note that multiple trailing 0's are allowed after the decimal point.

grep -E '^[+-]?(([1-9][0-9]*)?[0-9](\.[0-9]*)?|\.[0-9]+)$'

correctly matches the following:

9
0
10
10.
0.
0.0
0.100
0.10
0.01
10.0
10.10
.0
.1
.00
.100
.001

as well as their signed equivalents, whereas it rejects the following:

.
00
01
00.0
01.3

and their signed equivalents, as well as the empty string.

Upvotes: 5

Martin Lemnian
Martin Lemnian

Reputation: 41

All of the regexes here are wrong because they don't consider a lot of edge cases:

  • US format of numbers (1,000,000.00) vs. non-US (1.000.000,00)

Assuming only the US format the following numbers are valid:

0.1
.1

1
12
123

1234
1,234

12345
12,345

123456
123,456

123456789
123,456,789

1.0
12.0
123.0

1234.0
1,234.0

12345.0
12,345.0

123456.0
123,456.0

123456789.0
123,456,789.0

+0.1
+.1

+1.0
+12.0
+123.0

+1234.0
+1,234.0

+12345.0
+12,345.0

+123456.0
+123,456.0

+123456789.0
+123,456,789.0

-0.1
-.1

-1.0
-12.0
-123.0

-1234.0
-1,234.0

-12345.0
-12,345.0

-123456.0
-123,456.0

-123456789.0
-123,456,789.0

Assuming only the US format the following numbers are invalid:

1,000,
1,4
1,00
1,000,1
1,000,10

1.1.
1..1
..1
.1.
-1.1.
-1..1
-..1
-.1.

The following regex matches only the valid US numbers:

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

if you want non-US numbers:

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

see https://regexr.com/7guqk

Edit 1:

BTW: In some cases, numbers are represented in exponential form

4800 -> 4.80000000000000E+03

My regex doesn't consider those numbers yet.

Upvotes: 0

axellbrendow
axellbrendow

Reputation: 295

For those who wanna match the same thing as JavaScript does:

[-+]?(\d+\.?\d*|\.\d+)

Matches:

  • 1
  • +1
  • -1
  • 0.1
  • -1.
  • .1
  • +.1

Railroad diagram of the regex

Drawing: https://regexper.com/#%5B-%2B%5D%3F%28%5Cd%2B%5C.%3F%5Cd*%7C%5C.%5Cd%2B%29

Upvotes: 3

DevWL
DevWL

Reputation: 18840

Regular expression:

^\d+((.)|(.\d{0,1})?)$

use \d+ instead of \d{0,1} if you want to allow more then one number use \d{0,2} instead of \d{0,1} if you want to allow up to two numbers after coma. See the example below for reference:

enter image description here

or

^\d+((.)|(.\d{0,2})?)$

enter image description here

or

^\d+((.)|(.\d+)?)$

enter image description here

Explanation

(These are generated by regex101)

  • ^ asserts position at start of a line
  • \d matches a digit (equivalent to [0-9])
  • + matches the previous token between one and unlimited times, as many times as possible, giving back as needed (greedy)
  • 1st Capturing Group ((.)|(.\d{0,1})?)
  • 1st Alternative (.)
  • 2nd Capturing Group (.)
  • . matches any character (except for line terminators)
  • 2nd Alternative (.\d{0,1})?
  • 3rd Capturing Group (.\d{0,1})?
  • ? matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
  • . matches any character (except for line terminators)
  • \d matches a digit (equivalent to [0-9])
  • {0,1} matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
  • $ asserts position at the end of a line

Sandbox

Play with regex here: https://regex101.com/

Upvotes: 3

Luca Manzo
Luca Manzo

Reputation: 3411

this matches all requirements:

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

Upvotes: 31

Lawrence Eagles
Lawrence Eagles

Reputation: 727

try this. ^[0-9]\d{0,9}(\.\d{1,3})?%?$ it is tested and worked for me.

Upvotes: 3

PersyJack
PersyJack

Reputation: 1964

What you asked is already answered so this is just an additional info for those who want only 2 decimal digits if optional decimal point is entered:

^\d+(\.\d{2})?$

^ : start of the string
\d : a digit (equal to [0-9])
+ : one and unlimited times

Capturing Group (.\d{2})?
? : zero and one times . : character .
\d : a digit (equal to [0-9])
{2} : exactly 2 times
$ : end of the string

1 : match
123 : match
123.00 : match
123. : no match
123.. : no match
123.0 : no match
123.000 : no match
123.00.00 : no match

Upvotes: 2

Ahmed Abdulkafy
Ahmed Abdulkafy

Reputation: 148

you can use this:

^\d+(\.\d)?\d*$

matches:
11
11.1
0.2

does not match:
.2
2.
2.6.9

Upvotes: 6

OrangeDog
OrangeDog

Reputation: 38777

/\d+\.?\d*/

One or more digits (\d+), optional period (\.?), zero or more digits (\d*).

Depending on your usage or regex engine you may need to add start/end line anchors:

/^\d+\.?\d*$/

Regular expression visualization

Debuggex Demo

Upvotes: 156

James Miao
James Miao

Reputation: 129

This is what I did. It's more strict than any of the above (and more correct than some):

^0$|^[1-9]\d*$|^\.\d+$|^0\.\d*$|^[1-9]\d*\.\d*$

Strings that passes:

0
0.
1
123
123.
123.4
.0
.0123
.123
0.123
1.234
12.34

Strings that fails:

.
00000
01
.0.
..
00.123
02.134

Upvotes: 9

cvanniekerk
cvanniekerk

Reputation: 137

^\d+(()|(\.\d+)?)$

Came up with this. Allows both integer and decimal, but forces a complete decimal (leading and trailing numbers) if you decide to enter a decimal.

Upvotes: 1

Charles Naccio
Charles Naccio

Reputation: 358

I ended up using the following:

^\d*\.?\d+$

This makes the following invalid:

.
3.

Upvotes: 8

Hoylen
Hoylen

Reputation: 17030

You need a regular expression like the following to do it properly:

/^[+-]?((\d+(\.\d*)?)|(\.\d+))$/

The same expression with whitespace, using the extended modifier (as supported by Perl):

/^  [+-]? ( (\d+ (\.\d*)?)  |  (\.\d+) ) $/x

or with comments:

/^           # Beginning of string
 [+-]?       # Optional plus or minus character
 (           # Followed by either:
   (           #   Start of first option
     \d+       #   One or more digits
     (\.\d*)?  #   Optionally followed by: one decimal point and zero or more digits
   )           #   End of first option
   |           # or
   (\.\d+)     #   One decimal point followed by one or more digits
 )           # End of grouping of the OR options
 $           # End of string (i.e. no extra characters remaining)
 /x          # Extended modifier (allows whitespace & comments in regular expression)

For example, it will match:

  • 123
  • 23.45
  • 34.
  • .45
  • -123
  • -273.15
  • -42.
  • -.45
  • +516
  • +9.8
  • +2.
  • +.5

And will reject these non-numbers:

  • . (single decimal point)
  • -. (negative decimal point)
  • +. (plus decimal point)
  • (empty string)

The simpler solutions can incorrectly reject valid numbers or match these non-numbers.

Upvotes: 104

Prashant P
Prashant P

Reputation: 51

(?<![^d])\d+(?:\.\d+)?(?![^d])

clean and simple.

This uses Suffix and Prefix, RegEx features.

It directly returns true - false for IsMatch condition

Upvotes: 1

Jo&#227;o Silva
Jo&#227;o Silva

Reputation: 91309

Use the following:

/^\d*\.?\d*$/
  • ^ - Beginning of the line;
  • \d* - 0 or more digits;
  • \.? - An optional dot (escaped, because in regex, . is a special character);
  • \d* - 0 or more digits (the decimal part);
  • $ - End of the line.

This allows for .5 decimal rather than requiring the leading zero, such as 0.5

Upvotes: 288

Kash
Kash

Reputation: 9019

Try this regex:

\d+\.?\d*

\d+ digits before optional decimal
.? optional decimal(optional due to the ? quantifier)
\d* optional digits after decimal

Upvotes: 21

Luis
Luis

Reputation: 1235

What language? In Perl style: ^\d+(\.\d*)?$

Upvotes: 2

Related Questions