c# - 改变字符串的中间

Question

我有一个字符串列表.. 每个字符串看起来都类似于:

"\n\t\"BLOCK\",\"HEADER-\"\r\n\t\t\"NAME\",\"147430\"\r\n\t\t\"REVISION\",\"0000\"\r\n\t\t\"DATE\",\"11/11/10\"\r\n\t\t\"TIME\",\"10:03:47\"\r\n\t\t\"PMABAR\",\"\"\r\n\t\t\"COMMENT\",\"\"\r\n\t\t\"PTPNAME\",\"0805C\"\r\n\t\t\"CMPNAME\",\"0805C\"\r\n\t\"BLOCK\",\"PRTIDDT-\"\r\n\t\t\"PMAPP\",1\r\n\t\t\"PMADC\",0\r\n\t\t\"ComponentQty\",4\r\n\t\"BLOCK\",\"PRTFORM-\"\r\n\t\t\....(more)...."

我想做的是保留整个字符串，但是...替换 DATE、TIME 和 ComponentQty.... .

我想放置为 DATE 设置的 date 变量，以及 DateTime.Now.ToString(""HH:mm :ss") 用于 TIME ... 和 dictionary[part] 用于 ComponentQty。这些值将替换为所以:

"DATE","11/11/10"   with  "DATE","12/06/11"
"TIME","10:03:47"   with  "TIME","10:30:10"
"ComponentQty",4    with  "ComponentQty", 8

或类似的...

所以新的字符串看起来像这样:

"\n\t\"BLOCK\",\"HEADER-\"\r\n\t\t\"NAME\",\"147430\"\r\n\t\t\"REVISION\",\"0000\"\r\n\t\t\"DATE\",\"12/06/11\"\r\n\t\t\"TIME\",\"10:30:10"\"\r\n\t\t\"PMABAR\",\"\"\r\n\t\t\"COMMENT\",\"\"\r\n\t\t\"PTPNAME\",\"0805C\"\r\n\t\t\"CMPNAME\",\"0805C\"\r\n\t\"BLOCK\",\"PRTIDDT-\"\r\n\t\t\"PMAPP\",1\r\n\t\t\"PMADC\",0\r\n\t\t\"ComponentQty\",8\r\n\t\"BLOCK\",\"PRTFORM-\"\r\n\t\t\....(more)...."

做这样的事情最快的方法是什么？我在考虑正则表达式，但我不太确定如何去做。谁能帮忙？

编辑:

我只使用了一个普通的字符串替换来做到这一点..但是被替换的数据并不总是有我下面的 statc 日期、时间、compQty (11/11/10, 10: 03:47, 4)...我需要找到一种方法使该部分不被硬编码——我假设使用正则表达式..

var newDate = "DATE\",\"" + date + "\"";
var newTime = "TIME\",\"" + DateTime.Now.ToString("HH:mm:ss") + "\"";
var newCompQTY = "ComponentQty\"," + dictionary[part];

trimmedDataBasePart = trimmedDataBasePart.ToUpper().Replace("DATE\",\"11/11/10", newDate);
trimmedDataBasePart = trimmedDataBasePart.ToUpper().Replace("TIME\",\"10:03:47", newTime);
trimmedDataBasePart = trimmedDataBasePart.ToUpper().Replace("COMPONENTQTY\",4", newCompQTY);

我正在尝试为正则表达式设置一个值，但我不确定该怎么做......这就是我正在尝试的......但它显然不起作用，因为 var 是不是 string。有什么建议吗？

var newDate = "DATE\",\"" + date + "\"";
var regexedDate = Regex.Match(trimmedDataBasePart, "DATE\",[0-9]+/[0-9]+/[0-9]+");
trimmedDataBasePart = trimmedDataBasePart.ToUpper().Replace(regexedDate, newDate);

Answer 1

试试这个:

resultString = Regex.Replace(subjectString, @"(.*\bDATE\b\D*).*?(\\.*\bTIME\b\D*).*?(\\.*\bComponentQty\b\D*)\d+(.*)", "$1NEW_DATE$2NEW_TIME$3NEW_QTY", RegexOptions.Singleline);

NEW_DATE 应替换为您的日期，NEW_TIME 应替换为您的时间，NEW_QTY 应替换为您的新数量。

您可以根据需要从其他变量创建替换字符串:)

好吧好吧，.NET 和插值变量很糟糕。如果您尝试更改使用“$11”进行替换，它认为它必须使用反向引用 #11，但失败了。 Regexbuddy 也有一个产生错误正则表达式的错误。这已经过测试并且有效!

string subjectString = "\n\t\"BLOCK\",\"HEADER-\"\r\n\t\t\"NAME\",\"147430\"\r\n\t\t\"REVISION\",\"0000\"\r\n\t\t\"DATE\",\"11/11/10\"\r\n\t\t\"TIME\",\"10:03:47\"\r\n\t\t\"PMABAR\",\"\"\r\n\t\t\"COMMENT\",\"\"\r\n\t\t\"PTPNAME\",\"0805C\"\r\n\t\t\"CMPNAME\",\"0805C\"\r\n\t\"BLOCK\",\"PRTIDDT-\"\r\n\t\t\"PMAPP\",1\r\n\t\t\"PMADC\",0\r\n\t\t\"ComponentQty\",4\r\n\t\"BLOCK\",\"PRTFORM-\"\r\n\t\t....(more)....";
            Regex regexObj = new Regex(@"^(.*\bDATE\b\D*).*?(\"".*?\bTIME\b\D*).*?(\"".*?\bComponentQty\b\D*)\d+(.*)$", RegexOptions.Singleline);

            StringBuilder myResult = new StringBuilder();
            Match matchResults = regexObj.Match(subjectString);
            while (matchResults.Success)
            {
                for (int i = 1; i < matchResults.Groups.Count; i++)
                {
                    Group groupObj = matchResults.Groups[i];

                    if (groupObj.Success)
                    {
                        myResult.Append(groupObj.Value);
                        switch (i)
                        {
                            case 1:
                                myResult.Append("NEW_DATE");
                                break;
                            case 2:
                                myResult.Append("NEW_TIME");
                                break;
                            case 3:
                                myResult.Append("NEW QTY");
                                break;
                        }
                    }
                }
                matchResults = matchResults.NextMatch();
            }
            Console.WriteLine("Final Result : \n\n\n{0}", myResult.ToString());

输出:

Final Result :



        "BLOCK","HEADER-"
                "NAME","147430"
                "REVISION","0000"
                "DATE","NEW_DATE"
                "TIME","NEW_TIME"
                "PMABAR",""
                "COMMENT",""
                "PTPNAME","0805C"
                "CMPNAME","0805C"
        "BLOCK","PRTIDDT-"
                "PMAPP",1
                "PMADC",0
                "ComponentQty",NEW QTY
        "BLOCK","PRTFORM-"
                ....(more)....

顺便说一下，您的输入字符串中有一个错误转义的点。干杯，玩得开心! :)