我想获取两个字符串之间的文本。为此,我尝试了以下代码。
string q = "SELECT \"NORTHWIND\".\"CUSTOMER_DETAILS_NORTHWIND\".\"CUSTOMER_ID\" FROM \"NORTHWIND\".\"CUSTOMER_DETAILS_NORTHWIND\"";
Regex regex = new Regex("SELECT(.*)FROM");
var result = regex.Match(q).Value;
输出:从\"NORTHWIND\".\"CUSTOMER_DETAILS_NORTHWIND\"表中选择\"CUSTOMER_ID\"。
但我希望结果不包含SELECT和FROM关键字。
期望输出:\"NORTHWIND\".\"CUSTOMER_DETAILS_NORTHWIND\".\"CUSTOMER_ID\"
有人能建议我如何实现吗?