问题：从长字符串中提取“eventTime”和“neUID”之间的字符串。

字符串内容为：

{"alarmSeq":24374594,"alarmTitle":"CELL OPERATION DEGRADED","alarmStatus":1,"alarmType":"QUALITYOFSERVICE","origSeverity":2,"eventTime":"2023-03-31 21:32:15","alarmId":"13480574","specificProblemID":"7654","specificProblem":"CELL OPERATION DEGRADED","neUID":"1301NSWX2ENB000010B7E"}

提取长字符串_字符串

 

函数公式解决：

=MID(A2,FIND("eventTime",A2)-1,FIND("neUID",A2)-FIND("eventTime",A2)-1)

 

原博客各种作……所以换阵地了，不过每篇都搬过来，实在有点累，想看就自己看吧：http://blog.sina.com.cn/pureiceshadow