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

myiowa

例如：A1单元格是文本型数据，文本格式如下:
在关键字前【机构】有若干字符
【机构】可能重复0次到多次
若出现【机构】这个关键字后再经过若干字符，后面必有 "reply":"这个字符串
"reply":"X" X表达为0或多个字符串
如何把所有X的内容提取出来？

edwin11891

上附件，模拟需要的结果

wbjjzhu

猜一个

沈默00

正则提取，，，上附件，，模拟需要的结果

wp231957

如果reply 这个东西有 且唯一  那和其他什么重复不重复的 有毛线关系

myiowa

A1单元格内容
[{"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！"},{"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"},{"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":"15736392239","reply":"SHE DOES IT"},{"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"}]
例如：A1单元格是文本型数据，文本格式如下:
在关键字前【机构】有若干字符
【机构】在单元格中可能重复0次到多次
若出现【机构】这个关键字后再经过若干字符，后面必有 "reply":"这个字符串
"reply":"X" X表达为0或多个字符串
如何把所有X的内容提取出来？
最后输出的单元格为 ALL DO OVER SHE DOES IT HE DOES IT TOO

myiowa

wp231957 发表于 2024-10-15 08:49
如果reply 这个东西有 且唯一  那和其他什么重复不重复的 有毛线关系

reply不唯一

myiowa

A1单元格内容如下 [{"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！"},{"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 "},{"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":"15736392239","reply":"SHE DOES IT"},{"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"}]

myiowa

[{"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！"},{"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 "},{"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":"15736392239","reply":"SHE DOES IT"},{"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"}]
A1单元格内容如上所示

myiowa

沈默00 发表于 2024-10-15 07:23
正则提取，，，上附件，，模拟需要的结果

单元格内容如下
[{"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！"},{"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"},{"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"},{"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"}]
最后需要出来的结果为ALL DO OVER SHE DOES IT HE DOES IT TOO