Regular expression

[prabunewindia]

Hi,

I want to take the particular words from a text document.
i.e., Need to take all the sentence starts with "Alter" and End with "null"
Can any one help me to do this....

Rajendra Prabu Elias

[r035198x]

What have you done so far?
Hint: You may get away by just using the methods in the string class for this.

[prabunewindia]

What have you done so far?
Hint: You may get away by just using the methods in the string class for this.

thanks for reply

I want to do it thru regular expression.
I tried the below

txtOutput.Text="";         
Regex exp = new Regex("ALTER[\\D]*NULL", RegexOptions.Multiline);         
MatchCollection mcol= exp.Matches(txtInput.Text);         
foreach (Match mat in mcol)         
{
             txtOutput.Text = txtOutput.Text+ "\n" + mat.Value.ToString();         
}

I dont know what to give for {allow any character}. thats why I tried with [\\D].

If I have more line like "Alter ..... NULL" then it should display all the lines.
Now it is display getting "alter .... null .... alter.... null" into a single sentence.

[r035198x]

Why do you want to do it in regex when simple StartsWith and EndsWith methods will do the job?

[prabunewindia]

Why do you want to do it in regex when simple StartsWith and EndsWith methods will do the job?

Thaks for reply

I will tell you my exact meed.

I will have a text document (SQL script).

I want to find particular sentence Starts with "ALTER" and end with "NULL"

It may occur in many times. So I need to list all the lines. With my above method, it displayed first a single setance by considering first ALTER and last NULL. But I i.e., It displayed all the sentence from first ALTER and before last NULL.

Regards,
Rajendra Prabu

[r035198x]

You can use .* to match any characters.