文本處理，awk or sed

莫俠007

原文如下：
[2005/02/18 13:44:23 B0099S05] SELECT a,
|| b,
|| from dual;
[2005/02/18 13:44:23 B0099S05] UPDATE MATERIAL T
|| SET T.CDELDATE = '20050216'
[2005/02/18 13:44:23 B0099S05] DELETE * from MATERIAL;
aaaaaaaaaaa
bbbbbbbbbb
PL/SQL over!。


處理后：
要求:
1:將文件中所有含有B0099S05的行,的下一行含有||的去掉||合成一行,生成另一個(gè)
文件; 即新文件應(yīng)該如下:
[2005/02/18 13:44:23 B0099S05] SELECT a, b, from dual;
[2005/02/18 13:44:23 B0099S05] UPDATE MATERIAL T SET T.CDELDATE = '20050216'
[2005/02/18 13:44:23 B0099S05] DELETE * from MATERIAL;

zxy877298415

回復(fù) 1# 莫俠007
awk '{if($0~/^\[/) {if (NR>1) print "";printf gensub(/[|]/,"","g",$0)} else if($0~/^\|/) {printf  gensub(/[|]/,"","g",$0)}}END{print ""}' FILE


   

Herowinter

回復(fù) 1# 莫俠007

1. sed ':1;/B0099S05/{:2;N;s/\n||//;t2;b1}' i
   
2. [2005/02/18 13:44:23 B0099S05] SELECT a, b, from dual;
   
3. [2005/02/18 13:44:23 B0099S05] UPDATE MATERIAL T SET T.CDELDATE = '20050216'
   
4. [2005/02/18 13:44:23 B0099S05] DELETE * from MATERIAL;
   
5. aaaaaaaaaaa
   
6. bbbbbbbbbb
   
7. PL/SQL over!.

復(fù)制代碼

jason680

回復(fù) 1# 莫俠007

$ awk '/^\[/{printf N $0;N="\n"}/^\|\|/{printf $0}END{print""}' FILE
[2005/02/18 13:44:23 B0099S05] SELECT a,|| b,|| from dual;
[2005/02/18 13:44:23 B0099S05] UPDATE MATERIAL T|| SET T.CDELDATE = '20050216'
[2005/02/18 13:44:23 B0099S05] DELETE * from MATERIAL;

莫俠007

@zxy877298415 @jason680 @Herowinter
awk的寫法都是匹配以^[ 開頭就換行
而sed的寫法，看得不是那么直觀，我看看sed的高級用法先

莫俠007

@Herowinter
http://www.groad.net/bbs/thread-6845-1-1.html
再一次謝謝你 看明白 你的寫法了

fangang001

回復(fù) 4# jason680

awk '/^\[/{printf N $0;N="\n"}/^\|\|/{printf $0}END{print""}'  china.data | sed -e 's/||//g'


   

Herowinter

回復(fù) 6# 莫俠007


這么快就能看明白，佩服，我剛學(xué)sed的時(shí)候這種代碼要想好久才能明白。

jason680

回復(fù) 7# fangang001

Thank you for your notice

$ awk '/^\[/{printf N $0;N="\n"}sub(/^\|\|/,""){printf $0}END{print""}' FILE
[2005/02/18 13:44:23 B0099S05] SELECT a, b, from dual;
[2005/02/18 13:44:23 B0099S05] UPDATE MATERIAL T SET T.CDELDATE = '20050216'
[2005/02/18 13:44:23 B0099S05] DELETE * from MATERIAL;

   

chengchow

1. [root@pmaster tmp]# sed -r '1h;1!H;$!d;${g;s/\n\|\|//g}' 1
   
2. [2005/02/18 13:44:23 B0099S05] SELECT a, b, from dual;
   
3. [2005/02/18 13:44:23 B0099S05] UPDATE MATERIAL T SET T.CDELDATE = '20050216'
   
4. [2005/02/18 13:44:23 B0099S05] DELETE * from MATERIAL;
   
5. aaaaaaaaaaa
   
6. bbbbbbbbbb
   
7. PL/SQL over!.

復(fù)制代碼