单元格中有多个重复字符的查找函数

wp231957

myiowa 发表于 2024-10-15 11:08
单元格内容如下
[{"createUserId":98444495504683626498,"managePlaceCode":"342343432435","managePlac ...

专业的东西 就要找专业的工具来做
你这原始数据  再添加一对引号  就构成了标准的json格式数据

1. s=[
   
2.     {"createUserId":98444495504683626498,"managePlaceCode":"342343432435","managePlaceLevel":1,"title":"【problem】","createNickName":"八戒","id":"1232254164536131654_84614364MA342D23SDF_202401001_00_2134124544321","time":"2024-09-10 14:35:25","managePlaceName":"AACDADFA","createName":"56212131311","reply":"ABCDEFGHIHJKJKLHALFD！"},
   
3.     {"createUserId":"212102021021212120S","managePlaceCode":"987654321111","managePlaceLevel":6,"title":"【A1 机构】","createNickName":"ABCDEFGD","id":"1232254164536131654_84614364MA342D23SDF_202401001_987654321111_1728617379748","time":"2024-09-12 11:29:39","managePlaceName":"ABCDEFGHIGHTA","createName":"84614364MA342D23SDF","reply":"ALL DO OVER"},
   
4.     {"createUserId":1815555737716269065,"managePlaceCode":"987654321110","managePlaceLevel":5,"title":"【A2 机构】","createNickName":"嫦娥","id":"1232254164536131654_84614364MA342D23SDF_202401001_987654321_1728619234309","time":"2024-09-12 12:00:34","managePlaceName":"CDEFGAG","createName":"52121214521","reply":"SHE DOES IT"},
   
5.     {"createUserId":1753964276509413381,"managePlaceCode":"ASDF71000000","managePlaceLevel":4,"title":"【A3 机构】","createNickName":"吴刚","id":"1232254164536131654_84614364MA342D23SDF_202401001_ASDF71_1728627247736","time":"2024-09-12 14:14:07","managePlaceName":"RFGADAFA","createName":"852741945745","reply":"HE DOES IT TOO"}
   
6.     ]   
   
7. for x in s:
   
8.     if "机构" in x["title"]:
   
9.         print(x["reply"])

复制代码

运行结果如下：
PS C:\Users\Administrator> & D:/Python39/python.exe d:/wp/tmp.py
ALL DO OVER
SHE DOES IT
HE DOES IT TOO

myiowa

wp231957 发表于 2024-10-15 11:44
专业的东西 就要找专业的工具来做
你这原始数据  再添加一对引号  就构成了标准的json格式数据

谢谢，但是现在只有WPS没有PYTHON

kevinchengcw