shell 如何将一行数据中,将含有指定字符串AAA的后面第X个字符提取出来?

B2="score "&LOOKUP(9^9,--LEFT(RIGHT(A2,LEN(A2)-MIN(IFERROR(FIND(ROW($1:$10)-1,A2),4^8))+1),ROW($1:$50)))

数组公式向下复制【数组公式，公式输完后，光标放在公式编辑栏同时按下CTRL+SHIFT+回车键，使数组公式生效】

这个公式仅对字符串中只有一组数字的特例起作用。

假设你的数据在A列，且从A1开始
B1="score "&MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"""",""),"score/>afdfdasd","宋"),FIND("座",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"""",""),"score/>afdfdasd","宋"))+1,FIND("宋",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"""",""),"score/>afdfdasd","宋"))-FIND("座",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"""",""),"score/>afdfdasd","宋"))-1)
有点长，经过2个替换关键字，然后查找2个关键字之间的位置就是 数据。