Regular expressions question

[Carlos Guzmán Álvarez]

Hello:
I want to know if it's possible to obtain the SQL commands stored on a
string using as delimiter a ; character using Regular expressions (i
have tryed it for some time without any result :)),anything like this
(but supporting any combination of SQL commands ;)):

"INSERT INTO TESTTABLE VALUES ( 'This is a semi-colon ;' );" +
"INSERT INTO TESTTABLE VALUES ( 'This is not a semi-colon !' )"

Giving as result:

INSERT INTO TESTTABLE VALUES ( 'This is a semi-colon ;' )
"INSERT INTO TESTTABLE VALUES ( 'This is not a semi-colon !' )

Is this possible using Regular expressions


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Brian Davis]

Instead of using Split, you could use the Regex.Matches method with the
following expression:

[^';]+('[^']*')?[^';]*(?=;)
If you need to use Split, this expression seems to work (although you should
test it thouroughly):

(?n)(?<=(^|;)[^']*('[^']*')?[^']*);

Brian Davis
www.knowdotnet.com
"Carlos Guzmán Álvarez" <ca******@telefonica.net> wrote in message
news:e8**************@TK2MSFTNGP11.phx.gbl...

Hello:
I want to know if it's possible to obtain the SQL commands stored on a
string using as delimiter a ; character using Regular expressions (i
have tryed it for some time without any result :)),anything like this
(but supporting any combination of SQL commands ;)):

"INSERT INTO TESTTABLE VALUES ( 'This is a semi-colon ;' );" +
"INSERT INTO TESTTABLE VALUES ( 'This is not a semi-colon !' )"

Giving as result:

INSERT INTO TESTTABLE VALUES ( 'This is a semi-colon ;' )
"INSERT INTO TESTTABLE VALUES ( 'This is not a semi-colon !' )

Is this possible using Regular expressions


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain