fork download
  1. using System;
  2. using System.Text.RegularExpressions;
  3. using System.Collections.Specialized;
  4. class Program
  5. {
  6. static void Main() {
  7. string s1 = @"show database;
  8. insert into table_x values (""string;s"",""id_s"",1);
  9. insert into table2_x values (""s;s"",1);";
  10. var myRegex = new Regex(@"""[^""]*""|((?=;))");
  11. string replaced = myRegex.Replace(s1, delegate(Match m) {
  12. if (m.Groups[1].Value == "") return m.Value;
  13. else return "SplitHere";
  14. });
  15. string[] splits = Regex.Split(replaced,"SplitHere");
  16. Console.WriteLine("*** HERE ARE THE SPLIT STRINGS ***");
  17. foreach (string split in splits) Console.WriteLine(split);
  18. Console.WriteLine("\nPress Any Key to Exit.");
  19. Console.ReadKey();
  20. } // END Main
  21. } // END Program
Success #stdin #stdout 0.08s 34096KB
stdin
Standard input is empty
stdout
*** HERE ARE THE SPLIT STRINGS ***
show database; 
insert into table_x values ("string;s","id_s",1);
insert into table2_x values ("s;s",1);

Press Any Key to Exit.