Regex

http://regexr.com/

http://regexhero.net/tester

https://www.myregextester.com/index.php#sourcetab

;(?=(?:[^']*'[^']*')*[^']*$)(?=(?:[^"]*"[^"]*")*[^"]*$)

http://stackoverflow.com/questions/3147836/c-sharp-regex-split-commas-outside-quotes

De doel is om de text hieronder te knippen in 8 lossen opdrachten. Het einde van een opdracht wordt erkend aan de ;

DROP TABLE test;

-- My comment

create table

-- comment 2

[test] ([ID] int, [NAME] Text);

insert into test (ID, NAME) VALUES (1, 'toto'); -- comment 3

insert into test (ID, NAME) VALUES (1, 'ti;ti');

insert into test (ID, NAME) VALUES (1, 'tata');

insert into test (ID, NAME) VALUES (1, "ti;ti");

insert into test (ID, NAME) VALUES (1, "tata");

insert into test (ID, NAME) VALUES (1, "ta';'ta");