提取网页源码内容绘制成表格

laoxi21

怎么提取下面网页中部分内容的字段  汇总成表格？
names字段      skuId字段     price字段     stock字段


  TShop.Setup(
                  {"valItemInfo":{"skuList":[
{"names":"34 黑色 ","pvs":"20549:147478970;1627207:28341","skuId":"4505153839497"},
{"names":"35 黑色 ","pvs":"20549:296172561;1627207:28341","skuId":"4319668156744"},
{"names":"36 黑色 ","pvs":"20549:59280855;1627207:28341","skuId":"4319668156745"},
{"names":"37 黑色 ","pvs":"20549:72380707;1627207:28341","skuId":"4319668156746"},
{"names":"38 黑色 ","pvs":"20549:103189693;1627207:28341","skuId":"4319668156747"},
{"names":"39 黑色 ","pvs":"20549:418624880;1627207:28341","skuId":"4319668156748"},
{"names":"40 黑色 ","pvs":"20549:229418985;1627207:28341","skuId":"4319668156749"},
{"names":"41 黑色 ","pvs":"20549:407396361;1627207:28341","skuId":"4319668156750"},
{"names":"42 黑色 ","pvs":"20549:473680452;1627207:28341","skuId":"4319668156751"},
{"names":"43 黑色 ","pvs":"20549:225078235;1627207:28341","skuId":"4319668156752"},
{"names":"44 黑色 ","pvs":"20549:64797379;1627207:28341","skuId":"4319668156753"},
{"names":"34 白色 ","pvs":"20549:147478970;1627207:28320","skuId":"4505153839495"},
{"names":"35 白色 ","pvs":"20549:296172561;1627207:28320","skuId":"4319668156754"},
{"names":"36 白色 ","pvs":"20549:59280855;1627207:28320","skuId":"4319668156755"},
{"names":"37 白色 ","pvs":"20549:72380707;1627207:28320","skuId":"4319668156756"},
{"names":"38 白色 ","pvs":"20549:103189693;1627207:28320","skuId":"4319668156757"},
{"names":"39 白色 ","pvs":"20549:418624880;1627207:28320","skuId":"4319668156758"},
{"names":"40 白色 ","pvs":"20549:229418985;1627207:28320","skuId":"4319668156759"},
{"names":"41 白色 ","pvs":"20549:407396361;1627207:28320","skuId":"4319668156760"},
{"names":"42 白色 ","pvs":"20549:473680452;1627207:28320","skuId":"4319668156761"},
{"names":"43 白色 ","pvs":"20549:225078235;1627207:28320","skuId":"4319668156762"},
{"names":"44 白色 ","pvs":"20549:64797379;1627207:28320","skuId":"4319668156763"},
{"names":"34 绿色 ","pvs":"20549:147478970;1627207:28335","skuId":"4505153839496"},
{"names":"35 绿色 ","pvs":"20549:296172561;1627207:28335","skuId":"4505153839500"},
{"names":"36 绿色 ","pvs":"20549:59280855;1627207:28335","skuId":"4505153839504"},
{"names":"37 绿色 ","pvs":"20549:72380707;1627207:28335","skuId":"4505153839506"},
{"names":"38 绿色 ","pvs":"20549:103189693;1627207:28335","skuId":"4505153839494"},
{"names":"39 绿色 ","pvs":"20549:418624880;1627207:28335","skuId":"4505153839502"},
{"names":"40 绿色 ","pvs":"20549:229418985;1627207:28335","skuId":"4505153839499"},
{"names":"41 绿色 ","pvs":"20549:407396361;1627207:28335","skuId":"4505153839501"},
{"names":"42 绿色 ","pvs":"20549:473680452;1627207:28335","skuId":"4505153839503"},
{"names":"43 绿色 ","pvs":"20549:225078235;1627207:28335","skuId":"4505153839498"},
{"names":"44 绿色 ","pvs":"20549:64797379;1627207:28335","skuId":"4505153839505"}]
,"defSelected":[],"skuMap":
{";20549:418624880;1627207:28335;":
{"priceCent":15800,"price":"158.00","stock":358,"skuId":"4505153839502"},";20549:64797379;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":996,"skuId":"4319668156763"},";20549:72380707;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":899,"skuId":"4319668156746"},";20549:418624880;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":521,"skuId":"4319668156748"},";20549:407396361;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":2443,"skuId":"4319668156760"},";20549:296172561;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":943,"skuId":"4319668156744"},";20549:296172561;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":998,"skuId":"4505153839500"},";20549:229418985;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":499,"skuId":"4319668156749"},";20549:59280855;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":995,"skuId":"4319668156755"},";20549:147478970;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":871,"skuId":"4505153839495"},";20549:473680452;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":319,"skuId":"4319668156751"},";20549:225078235;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":426,"skuId":"4319668156762"},";20549:103189693;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":384,"skuId":"4505153839494"},";20549:229418985;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":980,"skuId":"4505153839499"},";20549:103189693;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":876,"skuId":"4319668156747"},";20549:64797379;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":848,"skuId":"4319668156753"},";20549:473680452;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":0,"skuId":"4505153839503"},";20549:72380707;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":390,"skuId":"4505153839506"},";20549:418624880;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":2005,"skuId":"4319668156758"},";20549:64797379;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":0,"skuId":"4505153839505"},";20549:296172561;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":876,"skuId":"4319668156754"},";20549:407396361;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":300,"skuId":"4319668156750"},";20549:407396361;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":0,"skuId":"4505153839501"},";20549:147478970;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":998,"skuId":"4505153839496"},";20549:59280855;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":923,"skuId":"4319668156745"},";20549:147478970;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":981,"skuId":"4505153839497"},";20549:229418985;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":2381,"skuId":"4319668156759"},";20549:225078235;1627207:28341;":{"priceCent":15800,"price":"158.00","stock":606,"skuId":"4319668156752"},";20549:59280855;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":996,"skuId":"4505153839504"},";20549:473680452;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":1850,"skuId":"4319668156761"},";20549:72380707;1627207:28320;":{"priceCent":15800,"price":"158.00","stock":1901,"skuId":"4319668156756"},";20549:225078235;1627207:28335;":{"priceCent":15800,"price":"158.00","stock":0,"skuId":"4505153839498"},";20549:103189693;1627207:28320;":

tony@cq

总得举个例子，要做什么效果出来？

libo5563

先用记事本把双引号改为+，再拷到pq里当一个文本处理，（最好能放到文本文件里，读取就简单多了），看要求好像只要上半部分，改列名，字段合并之类的，鼠标就可以搞定了吧

pbi12580

发帖原文的数据不全部，这是应该是一个完整 json ，获取数据里面选择 json，然后展开即可；
保留需要的项，删除不需要的列。

luzwales

下载的应该为Json文件改的Txt吧，要是复杂的Json文件，直接用Json文件导入