一、表达式

1. 查找excel中一列值出现在另外一列中

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH($A$1:$A$101,C2)))),1,0)

2.计算某个字符出现的次数

=LEN(G2)-LEN(SUBSTITUTE(G2,">",))+1

3.拼接字符串 

=C2&"|"&A2 

4.根据当前日期生成19位id

=TEXT(TODAY()+RAND()*10^18,REPT(0,18)) 

5.excel生成insert/update语句

="insert into rpum_pump_event_dict(id,EVENT_TYPE,EVENT_CODE,EVENT_NAME,create_By)

   values('"&A144&"','"&B144&"','"&D144&"','"&E144&"','"&I144&"')"

="update rpum_device  set DEVICE_name ='"&E1&"' ,DEPARTMENT_CODE=(select department_code from syst_department where department_name= '"&L1&"') where device_code='"&D1&"' ;"

6.