文本 | 需要提取的内容 | 得到的结果 |
search for <bird food> rice corn, cardinal lover <bird tray> for wild animals | 1. 需要提取 <bird food> 之前的所有字符和单词 | search for |
2. 需要提取<bird food> 和 <bird tray> 之间的所有字符和单词 | rice corn, cardinal lover | |
3. 需要提取<bird tray> 之后的所有字符和单词 | for wild animals | |
4. 需要提取<bird food> 之后的所有字符和单词 | rice corn, cardinal lover <bird tray> for wild animals |
公式如下:
D2=TRIM(LEFT(SUBSTITUTE(A2,"<bird food>",REPT(" ",99)),99))
D3=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"<bird food>",REPT(" ",99)),"<bird tray>",REPT(" ",99)),99,99))
D4=TRIM(RIGHT(SUBSTITUTE(A2,"<bird tray>",REPT(" ",99)),99))
D5=TRIM(RIGHT(SUBSTITUTE(A2,"<bird food>",REPT(" ",99)),99))