Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to write regex to verify a comma delimited list of values

I am using SobiPro, a directory system for joomla and I have a field that will have values that contain alphanumerics and hyphens only, so a sample of what might be in this text field would be:

Toy Kites, Plastic Wheels, 1-Way Gizmos, Metal Spools, 3M Wire Ties

This regex would validate what they enter on the form prior to a field save.

I thought this: (\w+)(,\s*\w+)*

But clearly I am not right, and it does not account for the hyphens.. any help! thanks!

like image 305
C Szymaszek Avatar asked Nov 28 '22 09:11

C Szymaszek


1 Answers

Try this:

^[-\w\s]+(?:,[-\w\s]*)*$

Using ^ and $ ensures that we validate the entire value, and don't just find a match somewhere within.

The first character class, [-\w\s]+ allows one or more alphanumeric, whitespace, or dash characters. The dash should go first in the class brackets.

The second group allows zero or more repetitions with separating commas. It is wrapped in non-capturing parentheses, a small performance optimization: (?: … )*

Notes:

  • This expression allows empty entries, such as A,B,,D. If you don't want to allow this, change the second-to-last * to a +.
  • The \w shorthand allows underscores. To prevent this, replace them with A-Za-z0-9.
like image 55
Jay Avatar answered Dec 06 '22 17:12

Jay