V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
This topic created in 4523 days ago, the information mentioned may be changed or developed.
编辑一个文件
形如
BEGIN
keyqwertyuiopsdfghjkldfghjkfs
sdfghjkldfghjkdfghjkl;
dfghjkdfghjklfghjkl
sdfghjkl;asdfghjklasdfghjk
COMMIT
UPDATE `xxx` set xxxxx
BEGIN
keyqwertyuiopsdfghjkldfghjkfs
sdfghjkldfghjkdfghjkl;
dfghjkdfghjklfghjkl
sdfghjkl;asdfghjklasdfghjk
COMMIT
UPDATE `xxx` set xxxxx
BEGIN
keyqwertyuiopsdfghjkldfghjkfs
sdfghjkldfghjkdfghjkl;
dfghjkdfghjklfghjkl
sdfghjkl;asdfghjklasdfghjk
COMMIT
UPDATE `xxx` set xxxxx
我想删掉其中从BEGIN到COMMIT结束的这个区块
只保留下各种sql语句
一开始我想只grep出sql语句到另外的文件，但因为这些语句包含了值后太乱，跨行的，转折的，还有一些错误需要手工修正，只能反过来，把所有从BEGIN到COMMIT的区块都删除。但居然尝试了半天没弄起来，求高手给个例子示范。
形如
BEGIN
keyqwertyuiopsdfghjkldfghjkfs
sdfghjkldfghjkdfghjkl;
dfghjkdfghjklfghjkl
sdfghjkl;asdfghjklasdfghjk
COMMIT
UPDATE `xxx` set xxxxx
BEGIN
keyqwertyuiopsdfghjkldfghjkfs
sdfghjkldfghjkdfghjkl;
dfghjkdfghjklfghjkl
sdfghjkl;asdfghjklasdfghjk
COMMIT
UPDATE `xxx` set xxxxx
BEGIN
keyqwertyuiopsdfghjkldfghjkfs
sdfghjkldfghjkdfghjkl;
dfghjkdfghjklfghjkl
sdfghjkl;asdfghjklasdfghjk
COMMIT
UPDATE `xxx` set xxxxx
我想删掉其中从BEGIN到COMMIT结束的这个区块
只保留下各种sql语句
一开始我想只grep出sql语句到另外的文件，但因为这些语句包含了值后太乱，跨行的，转折的，还有一些错误需要手工修正，只能反过来，把所有从BEGIN到COMMIT的区块都删除。但居然尝试了半天没弄起来，求高手给个例子示范。
 |
1
bravejoe Dec 21, 2013
:%s/BEGIN\_.\+COMMIT//g
|
|
2
bravejoe Dec 21, 2013
%s/BEGIN\_[^\(BEGIN\)]\+COMMIT//g
|
 |
3
xcatliu Dec 21, 2013
用宏吧
q1/BEGIN<enter><shift-v>/COMMIT<enter>d<esc>q 1000q |
|
4
xcatliu Dec 21, 2013
1000@1
|
 |
5
maga Dec 23, 2013
：v/UPDATE/d
|
 |
6
gongcheng Dec 23, 2013
二楼是正解。
|
Select Language