請教，AWK難題

jiqixiaomao

B,2013-07-13:17:00
test,aaa,bbb
mmm,ccc,ddd
B,2013-07-13:17:20
tes1t,aaa,bbb
m1,ccc11,ddd1
tes2t,aaa,bbb
m1,ccc11,ddd1
B,2013-07-13:17:30
taaa,aaa,bbb
m1,ccc11,ddd1
m1,ccc11,ddd1


如上面的數(shù)據(jù)，用awk 能否實現(xiàn)把時間列輸出到數(shù)據(jù)列后面，如

test,aaa,bbb,2013-07-13:17:00
mmm,ccc,ddd,2013-07-13:17:00
tes1t,aaa,bbb,2013-07-13:17:20
m1,ccc11,ddd1,2013-07-13:17:20
tes2t,aaa,bbb,2013-07-13:17:20
m1,ccc11,ddd1,2013-07-13:17:20
taaa,aaa,bbb,2013-07-13:17:30
m1,ccc11,ddd1,2013-07-13:17:30
m1,ccc11,ddd1,2013-07-13:17:30

WilliBhamlll

1. awk '/^B/{sub(/B/,"");s=$0;next}{print $0""s}' file

復制代碼

jiqixiaomao

多謝，報錯了，報語法錯

秋天的絮兒

回復 3# jiqixiaomao


    沒有啊，二樓的語法沒有問題啊�？梢暂敵龅陌�。

1. cc@MaintRoom[103]:% awk '/^B/{sub(/B/,"");s=$0;next}{print $0""s}' study
   
2. test,aaa,bbb,2013-07-13:17:00
   
3. mmm,ccc,ddd,2013-07-13:17:00
   
4. tes1t,aaa,bbb,2013-07-13:17:20
   
5. m1,ccc11,ddd1,2013-07-13:17:20
   
6. tes2t,aaa,bbb,2013-07-13:17:20
   
7. m1,ccc11,ddd1,2013-07-13:17:20
   
8. taaa,aaa,bbb,2013-07-13:17:30
   
9. m1,ccc11,ddd1,2013-07-13:17:30
   
10. m1,ccc11,ddd1,2013-07-13:17:30
    

復制代碼

秋天的絮兒

回復 3# jiqixiaomao


    沒有啊，二樓的語法沒有問題啊�？梢暂敵龅陌�。

1. cc@MaintRoom[103]:% awk '/^B/{sub(/B/,"");s=$0;next}{print $0""s}' study
   
2. test,aaa,bbb,2013-07-13:17:00
   
3. mmm,ccc,ddd,2013-07-13:17:00
   
4. tes1t,aaa,bbb,2013-07-13:17:20
   
5. m1,ccc11,ddd1,2013-07-13:17:20
   
6. tes2t,aaa,bbb,2013-07-13:17:20
   
7. m1,ccc11,ddd1,2013-07-13:17:20
   
8. taaa,aaa,bbb,2013-07-13:17:30
   
9. m1,ccc11,ddd1,2013-07-13:17:30
   
10. m1,ccc11,ddd1,2013-07-13:17:30
    

復制代碼

jiqixiaomao

SUN OS下有問題，LINUX下可以正常運行，多謝了

blackold

try:

1. awk -F, -v OFS=, '/^B/{p=$2;next}{print $0,p}' urfile

復制代碼

yinwei2012

@jiqixiaomao
awk -F"," '{if($1~/^B/)t=$2;else print $0","t;}'

whoislp

1. awk 'BEGIN{RS="B,"}{for(i=2;i<=NF;i++)print $i,$1 }' file

復制代碼

但是如果有下面這種記錄會有bug
B,2013-07-13:17:00
test,aaB,bbb