asp.net 正则表达式替换求助

Question

        var config = { "success": 1, "message": "成功", "cache": 1, "body":
          { "items": [
            { "Item": "基本参数", "Name": "车型名称", "ItemType": "1",
                    "ModelExcessIds":
                    [
                        { "Id": "11069", "Value": "奥迪A1 2012款 1.4 TFSI Urban" },
                        { "Id": "7117", "Value": "奥迪A1 2012款 1.4 TFSI Ego" },
                        { "Id": "7244", "Value": "奥迪A1 2012款 1.4 TFSI Ego plus" }
                    ] 
             },
            { "Item": "基本参数", "Name": "厂商指导价(元)", "ItemType": "1",
                "ModelExcessIds":
                    [
                    { "Id": "11069", "Value": "22.48万" }, { "Id": "7117", "Value": "24.98万" },
                    { "Id": "7244", "Value": "28.98万" }
                    ]
            },
            { "Item": "基本参数", "Name": "厂商", "ItemType": "1",
                "ModelExcessIds":
                    [
                    { "Id": "11069", "Value": "奥迪(进口)" },
                    { "Id": "7117", "Value": "奥迪(进口)" },
                    { "Id": "7244", "Value": "奥迪(进口)" }
                    ]
         }]}};怎么用正则表达式取出items

Answer 1

补充一下我做的数据采集·这是我采集到的js填充数据·我要在后台处理一下js得到json格式数据·插入数据库

Answer 2

取它          { "items": [
            { "Item": "基本参数", "Name": "车型名称", "ItemType": "1",
                    "ModelExcessIds":
                    [
                        { "Id": "11069", "Value": "奥迪A1 2012款 1.4 TFSI Urban" },
                        { "Id": "7117", "Value": "奥迪A1 2012款 1.4 TFSI Ego" },
                        { "Id": "7244", "Value": "奥迪A1 2012款 1.4 TFSI Ego plus" }
                    ] 
             },
            { "Item": "基本参数", "Name": "厂商指导价(元)", "ItemType": "1",
                "ModelExcessIds":
                    [
                    { "Id": "11069", "Value": "22.48万" }, { "Id": "7117", "Value": "24.98万" },
                    { "Id": "7244", "Value": "28.98万" }
                    ]
            },
            { "Item": "基本参数", "Name": "厂商", "ItemType": "1",
                "ModelExcessIds":
                    [
                    { "Id": "11069", "Value": "奥迪(进口)" },
                    { "Id": "7117", "Value": "奥迪(进口)" },
                    { "Id": "7244", "Value": "奥迪(进口)" }
                    ]
         }]}

Answer 3

 {\s"items"((?<o>{)|(?<-o>)}|[^{}]+)*(?(o)(?!))} 用平衡组来解决即可

Answer 4

    string json=@"  var config = { ""success"": 1, ""message"": ""成功"", ""cache"": 1, ""body"":
          { ""items"": [
            { ""Item"": ""基本参数"", ""Name"": ""车型名称"", ""ItemType"": ""1"",
                    ""ModelExcessIds"":
                    [
                        { ""Id"": ""11069"", ""Value"": ""奥迪A1 2012款 1.4 TFSI Urban"" },
                        { ""Id"": ""7117"", ""Value"": ""奥迪A1 2012款 1.4 TFSI Ego"" },
                        { ""Id"": ""7244"", ""Value"": ""奥迪A1 2012款 1.4 TFSI Ego plus"" }
                    ] 
             },
            { ""Item"": ""基本参数"", ""Name"": ""厂商指导价(元)"", ""ItemType"": ""1"",
                ""ModelExcessIds"":
                    [
                    { ""Id"": ""11069"", ""Value"": ""22.48万"" }, { ""Id"": ""7117"", ""Value"": ""24.98万"" },
                    { ""Id"": ""7244"", ""Value"": ""28.98万"" }
                    ]
            },
            { ""Item"": ""基本参数"", ""Name"": ""厂商"", ""ItemType"": ""1"",
                ""ModelExcessIds"":
                    [
                    { ""Id"": ""11069"", ""Value"": ""奥迪(进口)"" },
                    { ""Id"": ""7117"", ""Value"": ""奥迪(进口)"" },
                    { ""Id"": ""7244"", ""Value"": ""奥迪(进口)"" }
                    ]
         }]}};
        ";
        
           json = Regex.Match(json, @"\{\s*""Item(.|\s)*\}(?=\}\;)").Value;

Answer 5

        var config = {"success": 1,"message": "成功","cache": 1,"body": {"items":[{"Item":"基本参数","Name":"车型名称","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"奥迪A1 2012款 1.4 TFSI Urban"},{"Id":"7117","Value":"奥迪A1 2012款 1.4 TFSI Ego"},{"Id":"7244","Value":"奥迪A1 2012款 1.4 TFSI Ego plus"}]},{"Item":"基本参数","Name":"厂商指导价(元)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"22.48万"},{"Id":"7117","Value":"24.98万"},{"Id":"7244","Value":"28.98万"}]},{"Item":"基本参数","Name":"厂商","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"奥迪(进口)"},{"Id":"7117","Value":"奥迪(进口)"},{"Id":"7244","Value":"奥迪(进口)"}]},{"Item":"基本参数","Name":"级别","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"小型车"},{"Id":"7117","Value":"小型车"},{"Id":"7244","Value":"小型车"}]},{"Item":"基本参数","Name":"发动机","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"1.4T 122马力 L4"},{"Id":"7117","Value":"1.4T 122马力 L4"},{"Id":"7244","Value":"1.4T 122马力 L4"}]},{"Item":"基本参数","Name":"变速箱","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"7挡双离合"},{"Id":"7117","Value":"7挡双离合"},{"Id":"7244","Value":"7挡双离合"}]},{"Item":"基本参数","Name":"长×宽×高(mm)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"3954*1740*1416"},{"Id":"7117","Value":"3954*1740*1416"},{"Id":"7244","Value":"3954*1740*1416"}]},{"Item":"基本参数","Name":"车身结构","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"3门4座两厢车"},{"Id":"7117","Value":"3门4座两厢车"},{"Id":"7244","Value":"3门4座两厢车"}]},{"Item":"基本参数","Name":"最高车速(km/h)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"203"},{"Id":"7117","Value":"203"},{"Id":"7244","Value":"203"}]},{"Item":"基本参数","Name":"官方0-100加速(s)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"8.9"},{"Id":"7117","Value":"8.9"},{"Id":"7244","Value":"8.9"}]},{"Item":"基本参数","Name":"实测0-100加速(s)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"9.99"}]},{"Item":"基本参数","Name":"实测100-0制动(m)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"37.15"}]},{"Item":"基本参数","Name":"实测油耗(L)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"基本参数","Name":"工信部综合油耗(L)","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"5.5"},{"Id":"7117","Value":"5.5"},{"Id":"7244","Value":"5.5"}]},{"Item":"基本参数","Name":"整车质保","ItemType":"1","ModelExcessIds":[{"Id":"11069","Value":"两年不限公里"},{"Id":"7117","Value":"两年不限公里"},{"Id":"7244","Value":"两年不限公里"}]},{"Item":"车身","Name":"长度(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"3954"},{"Id":"7117","Value":"3954"},{"Id":"7244","Value":"3954"}]},{"Item":"车身","Name":"宽度(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"1740"},{"Id":"7117","Value":"1740"},{"Id":"7244","Value":"1740"}]},{"Item":"车身","Name":"高度(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"1416"},{"Id":"7117","Value":"1416"},{"Id":"7244","Value":"1416"}]},{"Item":"车身","Name":"轴距(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"2469"},{"Id":"7117","Value":"2469"},{"Id":"7244","Value":"2469"}]},{"Item":"车身","Name":"前轮距(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"车身","Name":"后轮距(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"车身","Name":"最小离地间隙(mm)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"车身","Name":"整备质量(Kg)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"1215"},{"Id":"7117","Value":"1215"},{"Id":"7244","Value":"1215"}]},{"Item":"车身","Name":"车身结构","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"两厢车"},{"Id":"7117","Value":"两厢车"},{"Id":"7244","Value":"两厢车"}]},{"Item":"车身","Name":"车门数(个)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"3"},{"Id":"7117","Value":"3"},{"Id":"7244","Value":"3"}]},{"Item":"车身","Name":"座位数(个)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"4"},{"Id":"7117","Value":"4"},{"Id":"7244","Value":"4"}]},{"Item":"车身","Name":"油箱容积(L)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"45"},{"Id":"7117","Value":"45"},{"Id":"7244","Value":"45"}]},{"Item":"车身","Name":"行李厢容积(L)","ItemType":"2","ModelExcessIds":[{"Id":"11069","Value":"270-920"},{"Id":"7117","Value":"270-920"},{"Id":"7244","Value":"270-920"}]},{"Item":"发动机","Name":"发动机型号","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"-"},{"Id":"7117","Value":"-"},{"Id":"7244","Value":"-"}]},{"Item":"发动机","Name":"排量(mL)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"1390"},{"Id":"7117","Value":"1390"},{"Id":"7244","Value":"1390"}]},{"Item":"发动机","Name":"排量(L)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"1.4"},{"Id":"7117","Value":"1.4"},{"Id":"7244","Value":"1.4"}]},{"Item":"发动机","Name":"进气形式","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"涡轮增压"},{"Id":"7117","Value":"涡轮增压"},{"Id":"7244","Value":"涡轮增压"}]},{"Item":"发动机","Name":"气缸排列形式","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"L"},{"Id":"7117","Value":"L"},{"Id":"7244","Value":"L"}]},{"Item":"发动机","Name":"气缸数(个)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"4"},{"Id":"7117","Value":"4"},{"Id":"7244","Value":"4"}]},{"Item":"发动机","Name":"每缸气门数(个)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"4"},{"Id":"7117","Value":"4"},{"Id":"7244","Value":"4"}]},{"Item":"发动机","Name":"压缩比","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"发动机","Name":"配气机构","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"DOHC"},{"Id":"7117","Value":"DOHC"},{"Id":"7244","Value":"DOHC"}]},{"Item":"发动机","Name":"缸径","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"发动机","Name":"冲程","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"0"},{"Id":"7117","Value":"0"},{"Id":"7244","Value":"0"}]},{"Item":"发动机","Name":"最大马力(Ps)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"122"},{"Id":"7117","Value":"122"},{"Id":"7244","Value":"122"}]},{"Item":"发动机","Name":"最大功率(kW)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"90"},{"Id":"7117","Value":"90"},{"Id":"7244","Value":"90"}]},{"Item":"发动机","Name":"最大功率转速(rpm)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"5000"},{"Id":"7117","Value":"5000"},{"Id":"7244","Value":"5000"}]},{"Item":"发动机","Name":"最大扭矩(N·m)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"200"},{"Id":"7117","Value":"200"},{"Id":"7244","Value":"200"}]},{"Item":"发动机","Name":"最大扭矩转速(rpm)","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"1500-4000"},{"Id":"7117","Value":"1500-4000"},{"Id":"7244","Value":"1500-4000"}]},{"Item":"发动机","Name":"发动机特有技术","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"-"},{"Id":"7117","Value":"-"},{"Id":"7244","Value":"-"}]},{"Item":"发动机","Name":"燃料形式","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"汽油"},{"Id":"7117","Value":"汽油"},{"Id":"7244","Value":"汽油"}]},{"Item":"发动机","Name":"燃油标号","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"97号（京95号）"},{"Id":"7117","Value":"97号（京95号）"},{"Id":"7244","Value":"97号（京95号）"}]},{"Item":"发动机","Name":"供油方式","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"直喷"},{"Id":"7117","Value":"直喷"},{"Id":"7244","Value":"直喷"}]},{"Item":"发动机","Name":"缸盖材料","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"铝"},{"Id":"7117","Value":"铝"},{"Id":"7244","Value":"铝"}]},{"Item":"发动机","Name":"缸体材料","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"铁"},{"Id":"7117","Value":"铁"},{"Id":"7244","Value":"铁"}]},{"Item":"发动机","Name":"环保标准","ItemType":"6","ModelExcessIds":[{"Id":"11069","Value":"国V"},{"Id":"7117","Value":"国V"},{"Id":"7244","Value":"国V"}]},{"Item":"变速箱","Name":"简称","ItemType":"3","ModelExcessIds":[{"Id":"11069","Value":"7挡双离合"},{"Id":"7117","Value":"7挡双离合"},{"Id":"7244","Value":"7挡双离合"}]},{"Item":"变速箱","Name":"挡位个数","ItemType":"3","ModelExcessIds":[{"Id":"11069","Value":"7"},{"Id":"7117","Value":"7"},{"Id":"7244","Value":"7"}]},{"Item":"变速箱","Name":"变速箱类型","ItemType":"3","ModelExcessIds":[{"Id":"11069","Value":"双离合变速箱(DCT)"},{"Id":"7117","Value":"双离合变速箱(DCT)"},{"Id":"7244","Value":"双离合变速箱(DCT)"}]},{"Item":"底盘转向","Name":"驱动方式","ItemType":"4","ModelExcessIds":[{"Id":"11069","Value":"前置前驱"},{"Id":"7117","Value":"前置前驱"},{"Id":"7244","Value":"前置前驱"}]},{"Item":"底盘转向","Name":"前悬挂类型","ItemType":"4","ModelExcessIds":[{"Id":"11069","Value":"麦弗逊式独立悬架"},{"Id":"7117","Value":"麦弗逊式独立悬架"},{"Id":"7244","Value":"麦弗逊式独立悬架"}]},{"Item":"底盘转向","Name":"后悬挂类型","ItemType":"4","ModelExcessIds":[{"Id":"11069","Value":"扭力梁式半独立悬架"},{"Id":"7117","Value":"扭力梁式半独立悬架"},{"Id":"7244","Value":"扭力梁式半独立悬架"}]},{"Item":"底盘转向","Name":"助力类型","ItemType":"4","ModelExcessIds":[{"Id":"11069","Value":"电动助力"},{"Id":"7117","Value":"电动助力"},{"Id":"7244","Value":"电动助力"}]},{"Item":"底盘转向","Name":"车体结构","ItemType":"4","ModelExcessIds":[{"Id":"11069","Value":"承载式"},{"Id":"7117","Value":"承载式"},{"Id":"7244","Value":"承载式"}]},{"Item":"车轮制动","Name":"前制动器类型","ItemType":"5","ModelExcessIds":[{"Id":"11069","Value":"通风盘式"},{"Id":"7117","Value":"通风盘式"},{"Id":"7244","Value":"通风盘式"}]},{"Item":"车轮制动","Name":"后制动器类型","ItemType":"5","ModelExcessIds":[{"Id":"11069","Value":"盘式"},{"Id":"7117","Value":"盘式"},{"Id":"7244","Value":"盘式"}]},{"Item":"车轮制动","Name":"驻车制动类型","ItemType":"5","ModelExcessIds":[{"Id":"11069","Value":"手刹"},{"Id":"7117","Value":"手刹"},{"Id":"7244","Value":"手刹"}]},{"Item":"车轮制动","Name":"前轮胎规格","ItemType":"5","ModelExcessIds":[{"Id":"11069","Value":"215/45 R16"},{"Id":"7117","Value":"215/45 R16"},{"Id":"7244","Value":"215/45 R16"}]},{"Item":"车轮制

Answer 6

动","Name":"后轮胎规格","ItemType":"5","ModelExcessIds":[{"Id":"11069","Value":"215/45 R16"},{"Id":"7117","Value":"215/45 R16"},{"Id":"7244","Value":"215/45 R16"}]},{"Item":"车轮制动","Name":"备胎规格","ItemType":"5","ModelExcessIds":[{"Id":"11069","Value":"非全尺寸"},{"Id":"7117","Value":"非全尺寸"},{"Id":"7244","Value":"非全尺寸"}]}]}}哥哥这是采集的数据·我提问的数据是我自己把多余的item删掉了·那个用你的表达式可以取到·怎么换源数据就提取不到了·由于代码太多我用两楼发出来了·麻烦帮看看·谢谢了

Answer 7

空格匹配的问题：{\s*"items"((?<o>{)|(?<-o>)}|[^{}]+)*(?(o)(?!))}

Answer 8

{\s*"items"((?<o>{)|(?<-o>)}|[^{}]+)*(?(o)(?!))}