Recovery of a string between two words

[!const]

I'd like to pick up a string into a text file. The string that I want to recover begins with ALTER TABLE and ends by GO.

ALTER TABLE [T_FA] WITH CHECK ADD FOREIGN KEY ([ID_MD])
REFERENCES [T_MD] ([ID_MD])
ON UPDATE CASCADE
ON DELETE CASCADE
GO

I tried several regular expressions but I can not find the right one. I found that it works but only if GO is on the second line ...

Regex maregex = new Regex (@ "ALTER TABLE (? <test> (.*)( \ S *)) GO");

How do I make my regex search goes on GO after several line breaks?

[fellah]

For research on multiple lines, overloads your builder with regex "RegexOptions.Singleline", so the "." same match any line breaks, which simplifies things a lot.

Regex taregex = new Regex(@"ALTER TABLE(?<test>.*)GO", RegexOptions.Singleline);

If you want the complete sql query in Groups [ "test"]:

Regex taregex2 = new Regex(@"(?<test>ALTER TABLE.*GO)", RegexOptions.Singleline);

[!const]

Thank you for your reply, however, an error may occur. Assuming that my connection string is like this:

ALTER TABLE [T_AA]  WITH CHECK ADD FOREIGN KEY([ID_BB])
REFERENCES [T_BB] ([ID_BB])
ON UPDATE CASCADE
ON DELETE CASCADE
GO

ALTER TABLE [T_FA]  WITH CHECK ADD FOREIGN KEY([ID_MD])
REFERENCES [T_MD] ([ID_MD])
ON UPDATE CASCADE
ON DELETE CASCADE
GO

The regex will send me the entire contents of this channel to be cut in two, stopping at the first "GO" ...

[fellah]

I have responded according to what was in the first message, I can not guess what you need. So you want to retrieve for each query "ALTER TABLE [NAME_OF_THE_TABLE]" to "GO"?

Here is one that can do this:

Regex taregex = new Regex(@"(?<req>ALTER TABLE \[(?<table>[\w]*)\](.+\n)*\bGO\b)" );

In Groups ["table"], you retrieve the table name and Groups ["req"], complete the request.

Multiple queries to retrieve, and use a MatchCollection course the game with a foreach, for example.

[!const]

Indeed, I had not said. Finally I did not think that this could happen. That is how I do:

string chain = @"ALTER TABLE [T_AA]  WITH CHECK ADD FOREIGN KEY([ID_BB])
REFERENCES [T_BB] ([ID_BB])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [T_FA]  WITH CHECK ADD FOREIGN KEY([ID_MD])
REFERENCES [T_MD] ([ID_MD])
ON UPDATE CASCADE
ON DELETE CASCADE
GO";
Regex maregex = new Regex(@"(?<req>ALTER TABLE \[(?<table>[\w]*)\](.+\n)*\bGO\b)" );
MatchCollection matches = maregex.Matches(chain);
Match premiermatch = matches[0];
Match secondmatch = matches[1];

when I run the code, permiermatch still contains all the ALTER TABLE. It starts from first to last ALTER TABLE GO. So the line in secondmatch by exception.

[fellah]

OK so there is no blank line between "GO" and "ALTER TABLE" then? It is normal that it does not then since I had the regex based on the fact that GO ALTER TABLE and were separated by a blank line (the famous (.+\N)*).

It is possible to have more details on the ALTER TABLE? They are always the same? :
ALTER TABLE [XXXX] WITH CHECK ADD FOREIGN KEY ([XXXX])
REFERENCES [XXXX] ([XXXX])
ON UPDATE CASCADE
ON DELETE CASCADE
GO

Or otherwise they have always 5 lines? Basically what are their common put a part "ALTER TABLE" and "GO"