|
最佳回答 |
|
0
|
snrtuemcLv8专家互助发布于2023-11-13 15:35
|
if(or(find("(",$$$)>0,find("{",$$$)>0),$$$,if(len($$$)=0,'',left($$$, FIND("〔", $$$) - 1) + "\n" + MID($$$, find("〔", $$$), find("〕", $$$) - find("〔", $$$) + 1) + "\n" + right($$$, (len($$$) - find("〕", $$$))))) |
|
|
|
|
最佳回答 |
|
0
|
Z4u3z1Lv6专家互助发布于2023-11-13 15:36
|
IF(or(left($$$,1)="(",left($$$,1)="{"),$$$,if(len($$$)=0,'',left($$$, FIND("〔", $$$) - 1) + "\n" + MID($$$, find("〔", $$$), find("〕", $$$) - find("〔", $$$) + 1) + "\n" + right($$$, (len($$$) - find("〕", $$$))))) |
|
|
|
|
最佳回答 |
|
0
|
GGGGGGGGGLv5初级互助发布于2023-11-13 15:39
|
if(len($$$)=0, "", if( INDEXOF($$$,0)="(" || INDEXOF($$$,0)="{", $$$, left($$$, FIND("〔", $$$) - 1) + "\n" + MID($$$, find("〔", $$$), find("〕", $$$) - find("〔", $$$) + 1) + "\n" + right($$$, (len($$$) - find("〕", $$$))) ) ) |
|
|
|
1min目标场景问卷
立即参与
