Regular expression to allow comma and space delimited number list

Question

I want to write a regular expression using javascript or jquery to allow comma delimited list of numbers OR space delimited numbers OR comma followed by a space delimited numbers OR a combination of any of the above ex anything that is not a digit, space or comma must be rejected

SHOULD PASS 111,222,333 111 222 333 111, 222, 333 111,222,333 444 555 666, 111, 222, 333,

should NOT pass: 111,222,3a 3a 111 222 3a etc etc

I tried the code below they seemed to work however when I typed 3a as a number, it PASSED!!! How? I cannot understand how my code allowed that letter to pass.

I want to reject anything that is not a space, comma or digit

or is there a better way to do this without regular expressions? I looked in google and did not find any answer.

Thank you in advance for any help.

var isNumeric = /[\d]+([\s]?[,]?[\d])*/.test(userInput);
var isNumeric = /^[\d\s,]*/.test(userInput);    
var isNumeric = /^[\d]*[\s,]*/.test(userInput); 
var isNumeric = /^[\d\s,]*/.test(userInput);    
var isNumeric = /\d+\s*,*/.test(userInput); 

if (isNumeric == false) {
    alert(isNumeric);
  return false;
}
else
      alert('is Numeric!!!');

Also the answer to your question is that you're leaving off `$` at the end of the regular expression, which means that the matched pattern may be followed by any subsequent characters. — Pointy, Jul 04 '13 at 14:19

score 10 · Accepted Answer · answered Jul 04 '13 at 14:17

10

Would the regular expression ^[\d,\s]+$ not do the trick?

answered Jul 04 '13 at 14:17

Grim...

16,518
7
45
61

You need a `*` or a `+`, and multiple commas in sequence might be undesirable – Pointy Jul 04 '13 at 14:18
Yup, just tested it and came to the same conclusion. – Grim... Jul 04 '13 at 14:19
but I tested /^[\d\s,]*/ and it still allows 3a because it sees 3. It is not rejecting 3a. it is so strange. – javafun Jul 04 '13 at 14:22
1

@javafun no, that regex will not match "3a". You're still forgetting the `$` at the end of the pattern! – Pointy Jul 04 '13 at 14:24
thank you , you are right, it seems to be working. let me test it and get back to you. Thank you all for your quick replies. – javafun Jul 04 '13 at 14:25

score 1 · Answer 2 · answered Jul 04 '13 at 14:20

1

Try this Regex... Click to view your demo

^[0-9 _ ,]*$

answered Jul 04 '13 at 14:20

Ganesh Rengarajan

2,006
13
26

SamWhan · Answer 3 · 2013-07-04T14:29:23.347

0

Guess ^(\d+[, ]+)*$ should do it.

Explanation: A group containing one or more digits followed by at least one space or comma. Group may be repeated any number of times.

It's doesn't handle everything though, like failing when there are commas without a number between (if that's what you want).

edited Jul 04 '13 at 14:29

answered Jul 04 '13 at 14:22

SamWhan

8,296
1
18
45

Regular expression to allow comma and space delimited number list

3 Answers3

Linked

Related