求助:在【查找选项】里选择“正则表达式”如何使用
环境:Microsoft SQL Server 2014版本(操作系统 WIN10 企业版本6.3.18363)
已知条件:
SQL编辑语句时,存在有以下500条 代码,就是以下的每一行字符需要快速替换为 GDGDGSA
----------------------------------------------------------------------------------
Combined gene 10333333330655701#
Combined gene 100655702#
Combined gene 100655703#
Combined gene 100655704#
Combined gene 100655733333333333305#
Combined gene 100655706#
Combined gene 100655707#
Combined gene 100655708#
Combined gene 100655709#
Combined gene 100655710#
Combined gene 100655711#
Combined gene 100655555555555712#
Combined gene 100655713#
Combined gene 100655714#
Combined gene 100655715#
Combined gene 100655716#
Combined gene 100655717#
Combined gene 100655718#
Combined gene 100644444444455719#
Combined gene 100655720#
Combined gene 100655721#
Combined gene 100655722#
Combined gene 100655723#
Combined gene 100655724#
Combined gene 100655725#
Combined gene 100444655726#
Combined gene 100655727#
Combined gene 100655728#
Combined gene 100655729#
Combined gene 100655730#
Combined gene 100655731#
Combined gene 100655732#
Combined gene 100655733#
Combined gene 100655734#
Combined gene 100654444444444445735#
Combined gene 100655736#
Combined gene 100655737#
Combined gene 100655738#
Combined gene 100655739#
Combined gene 100655740#
Combined gene 100655741#
.....
.....
Combined gene 1006511111111115741#
----------------------------------------------------------------------------------------
问题:
不是替换表格里的字段或字符(排除replace / update等语句),能用什么办法可以把这些字符 快速替换成 GDGD0SA
尝试:SQL编辑语句时,Ctrl+H 打开【 替换和查找】,点击【快速替换】,在【查找选项】里选择“正则表达式”但不知如何使用,求正解。如果这个方法行不通的话,还有什么办法实现要求。