Home > database >  Help: in [search option] choose "regular expressions" how to use
Help: in [search option] choose "regular expressions" how to use

Time:04-26

Environment: Microsoft SQL Server 2014 version (WIN10 enterprise operating system version 6.3.18363)
The known conditions:
When editing SQL statements, there are the following article 500 of the code, each line is the following characters need to quickly replace 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 #

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Question:
Not replace the form fields or characters (excluding the replace/update statement), can use any way to these characters quickly replace GDGD0SA
Try: when editing SQL statements, Ctrl + H open [replacement and search], click on the [quick replacement], in the [search option] choose "regular expressions" but don't know how to use, strives for the truth, if this method doesn't work, what is the way to implement requirements,
  • Related