Regex question - advanced

Question

Here is another Regex questions for the experts

I am building an Mysql insert with regex...

This is what the insert looks like... so far

(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#), (#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#), (#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#);

In a previous question someone helped me to write this regex expression to delete a value that is smalled than the example above

var stripped30 = htstring30.replace(/\((?:[^#\n]*?#[^#\n]*?#[,\s]?){0,8}\)[,;]\s*/ig, '');

This will remove the exeption below and delete it, leaving me with only the 9 tables that I want...

(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#),

Now I basically want to do the same thing but this time delete all the exceptions bigger than 9 - Can anybody please assist me to do this..

(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#),
(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#,  #text10#),
(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#,  #text10#,  #text11#);
(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#),
(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#),
(#text1#,#text2#,#text3#,#text4#,#text5#,#text6#, #text7#, #text8#, #text9#);

So that when their is an exception bigger than 9 that I may delete it

Thanks

Answer 1

You could use this regular expression to remove every line that has not 9 entries:

/^(?!\s*\((?:#[^#\n]*#(?:\s*,\s*#[^#\n]*#){8})\)[,;]\s*$).*/mg

Answer 2

you could try the following:

var stripped30 = htstring30.replace(/\((?:[^#\n]*?#[^#\n]*?#[,\s]?){10,}\)[,;]\s*/ig, '');

where the blank after the 10, indicates that there is no upper bound.

edit:

using my answer from the previous question, but updating it as I have to your example above, produces, for me, good results:

\(([\s]*#[^#]+#[\s]*,?){10,}\)[,;]*

let me know how you fare.