Regex for a simple decimal

Asked Oct 24 '20 at 21:12

Active Oct 24 '20 at 21:12

Viewed 38 times

Google Sheets colors a number in blue in its formula syntax:

It seems like the requirements are:

My first stab this was:

But this of course allows multiple .'s which I don't want. For example, it would allow 123.128.129.00. What would be a better regex for this?

asked Oct 24 '20 at 21:12

samuelbrody1249

Put the dot after + operator, then definitely again allow the user to enter digits. – Imran Faruqi Oct 24 '20 at 21:18
What about `.123` and `123.`? Are they valid decimals? – PM 77-1 Oct 24 '20 at 21:19
@PM77-1 did you actually look at that duplicate you posted? That's validating a single number, not multiple numbers in a formula string. Which answer did you think was applicable? – samuelbrody1249 Oct 24 '20 at 21:20
@PM77-1 yes, I'm not really interested in "how to validate a number" but moreso "what is the regex for numeric validation that Google Sheets uses". – samuelbrody1249 Oct 24 '20 at 21:21
@PM77-1 here's a visual: https://imgur.com/a/X9G9xaB. – samuelbrody1249 Oct 24 '20 at 21:22
You (yourself) presented a single number regex. If you are interested in something else then make an effort to be clear. – PM 77-1 Oct 24 '20 at 21:27
@PM77-1 agreed, thank you for the clarification. How does this answer look? https://stackoverflow.com/a/64519055/12283168 – samuelbrody1249 Oct 24 '20 at 23:52

0 Answers0