Regular Expressions. Q

[Benjamin]

I have string with data as follows.



myString = "~delete from t1~Delete from t2~Update t3 set c1='8'"

When I process this string I would like to get all these SQL statements one
at a time.

I know I can do this using string manipulation.

Is there any easy and efficient way to do these using regular expressions? I
am exploring Regular Expressions!!!

Thanks,

Benjamin

 

[Karl Seguin]

Benjamin, try:

Regex re = new Regex(@"(~(?<capture>[^\~]*))", RegexOptions.ExplicitCapture
| RegexOptions.Compiled);
MatchCollection mc = re.Matches("~delete from t1~Delete from t2~Update t3
set c1='8'");
for (int i = 0; i < mc.Count; ++i) {
Match m = mc;
string value = m.Groups[1].Value;
}

Karl

 

[Benjamin]

Thanks,
Benjamin

Benjamin, try:

Regex re = new Regex(@"(~(?<capture>[^\~]*))", RegexOptions.ExplicitCapture
| RegexOptions.Compiled);
MatchCollection mc = re.Matches("~delete from t1~Delete from t2~Update t3
set c1='8'");
for (int i = 0; i < mc.Count; ++i) {
Match m = mc;
string value = m.Groups[1].Value;
}

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/

I have string with data as follows.



myString = "~delete from t1~Delete from t2~Update t3 set c1='8'"

When I process this string I would like to get all these SQL statements one
at a time.

I know I can do this using string manipulation.

Is there any easy and efficient way to do these using regular

expressions?

I
am exploring Regular Expressions!!!

Thanks,

Benjamin