notepad++ 批量替换技巧

打开 notepad++,

将从sql server中查到的某列数据 copy到 notepad++,

如图所示:

开始操作，

1） ctrl + F

   search:  ^

   replace what: ,'

   wrap around: checked

  search mode: Regular expression

  click button: replace all

   如图：

2)

    search: \r\n

    replace with: '\r\n

   wrap around: checked

  search mode: extended (\n, \r, \t, \0, \x.... )

  click button: replace all

    如图：

3), 首尾的数据行稍微处理一下，

    copy到你要的地方，即可。

     eg:   

SELECT [Key], [Name] as CityName
FROM KBSERVICE.DBO.GEOGRAPHYTIER_New  A
WHERE [Key]
IN
(
  '3EAA64A5-3701-4E6A-87C3-2AC3A7613458'
  ,'784FCC9D-F967-4230-9B5B-1713A0E5F94F'
  ,'9DBD3BEE-EFDB-4124-A7D9-A0D24596B40E'
  ,'FB6BC3A9-5863-4E52-944F-62E7E5AD550D'
  ,'3B695D94-B7CC-4E12-9212-4B3F8B382AB7'
  ,'9DBD3BEE-EFDB-4124-A7D9-A0D24596B40E'
  ,'3B695D94-B7CC-4E12-9212-4B3F8B382AB7'
  ,'C57B190F-5EB7-4546-923C-469C6A8B1BA0'
  ,'DBD83D1A-57E5-468C-A8A3-822A48EF49F9'
  ,'3ED5AF3F-0DCF-4D98-BFA7-754BC18FD78E'
  ,'757D51EE-130B-43E6-B0B7-73E3B18823FB'
  ,'F047191F-188D-47FF-B125-D5CDF01621ED'
  ,'85FDCC91-A1E9-4EC8-9CE4-3391357CB3DC'
  ------ 
)