流星的隨筆記事~☆

string pattern = @"(?ims)"".\s*(?<host>http:.*?)\s*"".*?(?<name>\b\w+).*?""\s*(?<ext>\..*?)\s*""";
string sample = @"select ID,"" http://localhost/TestSite/"" + MESTNR + "".doc"" from TestMestLayer ";

Regex reg = new Regex(pattern);
Match m = reg.Match(sample);

string url = "";
string sql = "";
//比對成功
if (m.Success)
{
	//取群組值
	url = String.Concat(m.Groups["host"].Value, m.Groups["name"].Value, m.Groups["ext"].Value);
}

//取代符合比對字串
sql = Regex.Replace(sample, pattern, "${name}");

Console.WriteLine(url);
Console.WriteLine(sql);