Choosing the Right Regex Template

Question

Can someone help me with this regex? I use Javascript and classic ASP.

checkxls = checkxls.match(/'.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?';/ig)

I need to exactly match this pattern.

I am looking for a more elegant way to do this.

Answer 1

You can use a negative character class to avoid unnecessary backtracking:

/'[^']*'(?:, '[^']*'){13};/g

You can also remove case insensitive flags because there are no letters in your regular expression. This may give a slight performance improvement.

Answer 2

/('', ){13}'';/ig

Answer 3

/(?:'[^']*', ){13}'[^']*';/g