| 说明 | 文字 | 函数 | 结果 |
|---|---|---|---|
| 拼接 crm+ 截取倒数第二个某字符后文字+并替换某字符 | fefe/fe/343 | =SUBSTITUTE(CONCATENATE("cms:",RIGHT(C5,LEN(C5)-(FIND("☆",SUBSTITUTE(C5,"/","☆",LEN(C5)-LEN(SUBSTITUTE(C5,"/",""))-1))))),"/",":") | cms:fe:343 |
| excel 字符串拼接双引号 | cms:common:queryOssStsToken | =CONCATENATE("@RequiresPermissions(value = """&H2&""")") | @RequiresPermissions(value = "cms:common:queryOssStsToken") |
| sql拼接 update | =CONCATENATE("UPDATE tz_lease_vehicle SET number_plate = '"&H2&"' WHERE frame_number ='"&B2&"' ;") | ||
| sql 拼接 insert 要去掉双引号 | =CONCATENATE("INSERT INTO public.sys_permission(id,parent_id,name,url,component,component_name,redirect,menu_type,perms,perms_type,sort_no,always_show,icon,is_route,is_leaf,keep_alive,hidden,description,create_by,create_time,update_by,update_time,del_flag,rule_flag,status,internal_or_external,sys_type)VALUES('"&O2&"','1514883106687737857','"&F2&"',NULL,NULL,NULL,NULL,2,'"&H2&"','1',NULL,'f',NULL,'t','t','f','f',NULL,NULL,'2024-10-2516:59:09.411',NULL,NULL,0,NULL,'1','f','cms');") | INSERT INTO public.sys_permission(id,parent_id,name,url,component,component_name,redirect,menu_type,perms,perms_type,sort_no,always_show,icon,is_route,is_leaf,keep_alive,hidden,description,create_by,create_time,update_by,update_time,del_flag,rule_flag,status,internal_or_external,sys_type)VALUES('1850771942770814977','1514883106687737857','获取OSS的STSToken',NULL,NULL,NULL,NULL,2,'cms:common:queryOssStsToken','1',NULL,'f',NULL,'t','t','f','f',NULL,NULL,'2024-10-2516:59:09.411',NULL,NULL,0,NULL,'1','f','cms'); |
参考：https://blog.csdn.net/xinyuan_java/article/details/99719744
