提取长字符串

问题：从长字符串中提取“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)