如何將兩個(gè)文本按要求整合在一起？

iocg

回復(fù) 8# ly5066113

如果現(xiàn)在數(shù)據(jù)是這樣的。。改怎么調(diào)整代碼？？
A

1. 京,張三,A,1235,TOYOTA,申請,a,401
   
2. 津,李四,D,1237,HONDA,申請,b,401
   
3. 冀,王五,C,1235,MAZDA,申請,c,402
   
4. 皖,小明,D,1233,BUICK,申請,,501
   
5. 內(nèi)蒙古,小黃,E,1236,SATURN,申請,,501
   
6. 遼,小黃,F,1236,SUBARU,申請,f,601
   
7. 京,張三,A,1235,LEXUS,申請,g,630
   
8. 津,李四,D,1238,HONDA,申請,,701
   
9. 冀,王五,E,1235,MAZDA,申請,,801
   
10. 皖,小紅,D,1233,BUICK,申請,j,910

復(fù)制代碼

B

1. 京,張三,A,1235,TOYOTA,調(diào)整,a,901
   
2. 津,李四,D,1237,HONDA,撤銷,,905
   
3. 滬,小雨,B,1237,CITROEN,添加,,908
   
4. 冀,王五,C,1235,MAZDA,調(diào)整,,910
   
5. 京,張三,A,1235,TOYOTA,撤銷,,910
   
6. 皖,小明,D,1233,BUICK,調(diào)整,f,912
   
7. 吉,小胡,A,1237,Bentley,添加,g,1005
   
8. 滬,小雨,B,1237,CITROEN,撤銷,h,1006
   

復(fù)制代碼

想要的結(jié)果

1. 京,張三,A,1235,TOYOTA,申請,a,401
   
2. 內(nèi)蒙古,小黃,E,1236,SATURN,申請,,501
   
3. 遼,小黃,F,1236,SUBARU,申請,f,601
   
4. 京,張三,A,1235,LEXUS,申請,g,630
   
5. 津,李四,D,1238,HONDA,申請,,701
   
6. 冀,王五,E,1235,MAZDA,申請,,801
   
7. 皖,小紅,D,1233,BUICK,申請,j,910
   
8. 皖,小明,D,1233,BUICK,調(diào)整,f,912
   
9. 冀,王五,C,1235,MAZDA,調(diào)整,,910
   
10. 吉,小胡,A,1237,Bentley,添加,g,1005
    

復(fù)制代碼

對(duì)于本例子執(zhí)行了如下
津,李四,D,1237,HONDA,申請,b,401
津,李四,D,1237,HONDA,撤銷,,905       ==>撤銷上一條申請，結(jié)果是刪除該記錄

京,張三,A,1235,TOYOTA,申請,a,401
京,張三,A,1235,TOYOTA,調(diào)整,a,901
京,張三,A,1235,TOYOTA,撤銷,,910    ==>撤銷上一條調(diào)整，結(jié)果是只保留申請記錄

冀,王五,C,1235,MAZDA,申請,c,402
冀,王五,C,1235,MAZDA,調(diào)整,,910    ==>將申請改為調(diào)整，結(jié)果是只保留調(diào)整記錄

皖,小明,D,1233,BUICK,申請,,501
皖,小明,D,1233,BUICK,調(diào)整,f,912    ==>將申請改為調(diào)整，結(jié)果是只保留調(diào)整記錄

滬,小雨,B,1237,CITROEN,添加,,908
滬,小雨,B,1237,CITROEN,撤銷,h,1006   ==>撤銷上一條添加，結(jié)果是刪除新添加的記錄

吉,小胡,A,1237,Bentley,添加,g,1005   ==>添加新記錄

   大家來幫個(gè)忙 @bulletmarquis@李滿滿@rulebook

rulebook

回復(fù) 11# iocg

1.    awk -F, 'NR==FNR{t=$1","$2","$3","$4","$5;a[t]=$6;;aa[t]=$7","$8;next} {t=$1","$2","$3","$4","$5;b[t]=b[t]?b[t]" "$6:$6;bb[t]=$7","$8}END{for(i in b){split(b[i],p," ");if(length(p)%2==0&&p[length(p)]=="撤銷"){b[i]=""}else{b[i]==p[length(p)]}};for(i in a){if(a[i]=="申請"&&b[i]=="調(diào)整"){c[i]=i",調(diào)整,"bb[i]}else if(a[i]=="申請"&&b[i]=="撤銷"){;}else if(a[i]=="申請"&&b[i]==""){c[i]=i",申請,"aa[i]}};for(i in b){if(b[i]=="添加"){c[i]=i",添加,"bb[i]}};for(i in c){print c[i]}}' o oo

復(fù)制代碼

試試