一个批量取文本问题。

xfan

是这样的， 已经在一个页面中循环找到了商品的信息
大概是这样的一段代码。

[{"商品编号":563986250611,"quantity":384,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"L 建议100-110斤",
{"商品编号":563986250612,"quantity":384,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"XL 建议110-120斤",
{"商品编号":563986250613,"quantity":374,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"2XL 建议120-130斤",



想得到的输出结果是


商品编号：563986250611，颜色分类：粉红色，尺码：L 建议100-110斤
商品编号：563986250612，颜色分类：粉红色，尺码：XL 建议110-120斤

这样。不太会用正则， 我使用的是批量取文本。 然后发现的问题是  商品编号到可以正常取， 但是这个颜色分类和 尺码 因为是相同的 关键词，会出现两次。
求助大神







补充内容 (2020-6-9 19:09):
实际测试中我发现一个问题。因为有时候 这个商品的信息中  只有商品的编号这个是肯定出现的。如果这个商品没有其它的参数、比如型号大小之类的 就取不到。

Skewen

逍遥一仙LSG

标准JSON建议直接json解析呢

67449123

发完整文本.. json可解.

xfan

67449123 发表于 2020-6-9 18:17
发完整文本.. json可解.

[{"商品编号":563986250611,"quantity":370,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"L 建议100-110斤","spec_key_id":1226,"spec_value_id":1227}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-21\u002Fd1808f62324e29bdda741f01584d5247.jpeg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250612,"quantity":351,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"XL 建议110-120斤","spec_key_id":1226,"spec_value_id":1228}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-21\u002Fd1808f62324e29bdda741f01584d5247.jpeg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250613,"quantity":344,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"2XL 建议120-130斤","spec_key_id":1226,"spec_value_id":3566}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-21\u002Fd1808f62324e29bdda741f01584d5247.jpeg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250614,"quantity":360,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"3XL 建议130-140斤","spec_key_id":1226,"spec_value_id":3567}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-21\u002Fd1808f62324e29bdda741f01584d5247.jpeg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250615,"quantity":376,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"4XL 建议140-150斤","spec_key_id":1226,"spec_value_id":3611}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-21\u002Fd1808f62324e29bdda741f01584d5247.jpeg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250616,"quantity":371,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"粉红色","spec_key_id":8640,"spec_value_id":130167},{"spec_key":"尺码","spec_value":"5XL 建议150-160斤","spec_key_id":1226,"spec_value_id":3612}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-21\u002Fd1808f62324e29bdda741f01584d5247.jpeg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250617,"quantity":95,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"绿色","spec_key_id":8640,"spec_value_id":69264},{"spec_key":"尺码","spec_value":"L 建议100-110斤","spec_key_id":1226,"spec_value_id":1227}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002F9cb99c7c-ff64-41a6-a6fe-fe1ae96bb999.jpg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":95,"staticLimitQuantity":999999},{"商品编号":563986250618,"quantity":77,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"绿色","spec_key_id":8640,"spec_value_id":69264},{"spec_key":"尺码","spec_value":"XL 建议110-120斤","spec_key_id":1226,"spec_value_id":1228}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002F9cb99c7c-ff64-41a6-a6fe-fe1ae96bb999.jpg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":77,"staticLimitQuantity":999999},{"商品编号":563986250619,"quantity":76,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"绿色","spec_key_id":8640,"spec_value_id":69264},{"spec_key":"尺码","spec_value":"2XL 建议120-130斤","spec_key_id":1226,"spec_value_id":3566}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002F9cb99c7c-ff64-41a6-a6fe-fe1ae96bb999.jpg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":76,"staticLimitQuantity":999999},{"商品编号":563986250620,"quantity":76,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"绿色","spec_key_id":8640,"spec_value_id":69264},{"spec_key":"尺码","spec_value":"3XL 建议130-140斤","spec_key_id":1226,"spec_value_id":3567}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002F9cb99c7c-ff64-41a6-a6fe-fe1ae96bb999.jpg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":76,"staticLimitQuantity":999999},{"商品编号":563986250621,"quantity":101,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"绿色","spec_key_id":8640,"spec_value_id":69264},{"spec_key":"尺码","spec_value":"4XL 建议140-150斤","spec_key_id":1226,"spec_value_id":3611}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002F9cb99c7c-ff64-41a6-a6fe-fe1ae96bb999.jpg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999},{"商品编号":563986250622,"quantity":102,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value":"绿色","spec_key_id":8640,"spec_value_id":69264},{"spec_key":"尺码","spec_value":"5XL 建议150-160斤","spec_key_id":1226,"spec_value_id":3612}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002F9cb99c7c-ff64-41a6-a6fe-fe1ae96bb999.jpg","normalPrice":"42","groupPrice":"23.9","skuExpansionPrice":"0","defaultQuantity":100,"staticLimitQuantity":999999}],"thumbUrl":"https:\u002F\u002Ft00img.yangkeduo.com\u002Fgoods\u002Fimages\u002F2020-05-22\u002Fe660c09200ed39331fe9d051fb070e53.jpeg",”

xfan

Skwen 发表于 2020-6-9 18:00

比葫芦画瓢的加了一下参数  groupprice
商品编号":(.+?),[\S\s]*?spec_value":"(.+?)"[\S\s]*?spec_value":"(.+?)"[\S\s]*?groupPrice":"(.+?)"
好像是正确的。。。。有没有非正则的办法。。。

补充内容 (2020-6-9 19:04):
因为有时候 参数2、3 是空的 ，只有一个商品id  也就是没有 参数分类的时候。。。

67449123

xfan 发表于 2020-6-9 18:55
[{"商品编号":563986250611,"quantity":370,"isOnSale":1,"specs":[{"spec_key":"颜色分类","spec_value" ...

不完整,发txt文件上来..

补充内容 (2020-6-9 19:04):
后面少了,不过我把后面的删掉应该还是可以解析了..等会

xfan

67449123 发表于 2020-6-9 19:02
不完整,发txt文件上来..

补充内容 (2020-6-9 19:04):

这个我不太确定是 json  我最初的想法就是网页源代码中取一下商品信息。
然而发现  颜色参数这个 ，并不是每个商品都有  现在唯一能确定的是 商品编号肯定是有的。

67449123

json 解析商品.7z (51.68 KB, 下载次数: 4)

2020-6-9 19:09 上传

点击文件名下载附件

xfan

67449123 发表于 2020-6-9 19:09

这样就算中途某个参数缺失  也可以正常的取到  只不过是空白对吗。