Excel或数据库快速生成GUID
一般一些开发软件或者网站可以直接生成guid,
比如:https://www.iamwawa.cn/guid.html
但是在某些场景下,经常在一些excel或者数据库操作需要快速生成指定格式的guid,
比如在Excel表格或者数据库中,要对某个字段快速一次性生成所有guid,并带连接符:
oracle生成guid:select substr(sys_guid(),1,8)||'-'||substr(sys_guid(),9,4)||'-'||substr(sys_guid(),13,4)||'-'||substr(sys_guid(),17,4)||'-'||substr(sys_guid(),20,12)
Excel生成guid:
=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"-","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HEX(RANDBETWEEN(8,11)),DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)))