Execution Details | Result |
T-CN-4259-156.ABC S CO\. LTD.addd.4259.156.sweeny/grace.CP14-034234..CTS - LAB Testing.Regular...EEC00000.Ag Cu 55合金丝.... | SHADOW/CRYSTAL.CP14-034929 |
公式如下:
=MID(N4,FIND("@",SUBSTITUTE(N4,".","@",6))+1,FIND("@",SUBSTITUTE(N4,".","@",8))-FIND("@",SUBSTITUTE(N4,".","@",6))-1)
目的是要取出当中的字符串。思路是:找到第六个"." 和第八个“.”之间的字符位置,然后取出。FIND("@",SUBSTITUTE(N4,".","@",6))中的SUBSTITUTE是查出第六个点,然后用@代替,再用FIND函数查到其位置(因为FIND函数只能查到第一个标识字符的位置,所以才这么麻烦)