演示数据(load sample data)
......
add F
(
正则表达式拆分json字符串:
正则表达式(?<={)([^{]*?)(?=})错在哪-Excel VBA程序开发-ExcelHome技术论坛) (
背景background
)
copy from Excel(video)
f01 "代码,名称,上市日,流通股,总股本,拼音码 {"rc":0,"rt":6,"svr":181735164,"lt":1,"full":1,"dlmkts":"","data":{"total":5138,"diff":{"0":{"f12":"000001","f14":"平安银行","f26":19910403,"f38":19405918198.0,"f39":19405546950.0},"1":{"f12":"000002","f14":"万 科A","f26":19910129,"f38":11930709471.0,"f39":9717360740.0},"2":{"f12":"000003","f14":"PT金田A","f26":19910703,"f38":0.0,"f39":0.0},"3":{"f12":"000004","f14":"ST国华","f26":19910114,"f38":132848008.0,"f39":118916853.0}}}}"