文件内容整理

linux_caiji

场景如下：

文件内容

aaa,bbb,ccc,ddd
111,222,333,444
555,666,777,888
122,133,144,155
eee,fff,ggg,hhh
......(n行)
hhh,ttt,fft,eef

需求后的格式
APPLICATION_LIST;
aaa=111;
bbb=222;
ccc=333;
ddd=444;
END;
APPLICATION_LIST;
aaa=555;
bbb=666;
ccc=777;
ddd=888;
END;
APPLICATION_LIST;
aaa=122;
bbb=133;
ccc=144;
ddd=155;
END;
APPLICATION_LIST;
aaa=eee;
bbb=fff;
ccc=ggg;
ddd=hhh;
END;
...（n行）
APPLICATION_LIST;
aaa=hhh;
bbb=ttt;
ccc=fft;
ddd=eef;
END;

请高手指导！

jason680

回复 1# linux_caiji

$ cat FILE
aaa,bbb,ccc,ddd
111,222,333,444
555,666,777,888
122,133,144,155
eee,fff,ggg,hhh
hhh,ttt,fft,eef

$ awk -F, 'NR==1{split($0,a);next}{s="APPLICATION_LIST;\n";for(n=1;n<=NF;++n)s=s a[n]"="$n";\n";print s"END;"}' FILE
APPLICATION_LIST;
aaa=111;
bbb=222;
ccc=333;
ddd=444;
END;
...
APPLICATION_LIST;
aaa=hhh;
bbb=ttt;
ccc=fft;
ddd=eef;
END;


   

Herowinter

回复 1# linux_caiji

1. 
   
2. awk -F, -vheader="APPLICATION_LIST;" -vfooter="END;" 'NR==1{for(i=1;i<=NF;i++)a[i]=$i} NR>1{print header;for(i=1;i<=NF;i++)print a[i]"="$i";";print footer}' i
   
3. APPLICATION_LIST;
   
4. aaa=111;
   
5. bbb=222;
   
6. ccc=333;
   
7. ddd=444;
   
8. END;
   
9. APPLICATION_LIST;
   
10. aaa=555;
    
11. bbb=666;
    
12. ccc=777;
    
13. ddd=888;
    
14. END;
    
15. APPLICATION_LIST;
    
16. aaa=122;
    
17. bbb=133;
    
18. ccc=144;
    
19. ddd=155;
    
20. END;
    
21. APPLICATION_LIST;
    
22. aaa=eee;
    
23. bbb=fff;
    
24. ccc=ggg;
    
25. ddd=hhh;
    
26. END;
    
27. APPLICATION_LIST;
    
28. aaa=hhh;
    
29. bbb=ttt;
    
30. ccc=fft;
    
31. ddd=eef;
    
32. END;
    

复制代码

haooooaaa

1. awk -vRS= -F'\n|,' '{for(i=5;i<=NF;i++){m=i%4;print (m==1?"APPLICATION_LIST;\n":"")($(m?m:4)"="$i";")(m?"":"\nEND;")}}'

复制代码

sunzhiguolu

1. perl -F/,/ -anle 'if($.==1){@a=@F;next}print"APPLICATION_LIST;";print "$a[$_]=$F[$_];" for 0..$#F;print "END;"' f

复制代码

APPLICATION_LIST;
aaa=111;
bbb=222;
ccc=333;
ddd=444;
END;
APPLICATION_LIST;
aaa=555;
bbb=666;
ccc=777;
ddd=888;
END;
APPLICATION_LIST;
aaa=122;
bbb=133;
ccc=144;
ddd=155;
END;
APPLICATION_LIST;
aaa=eee;
bbb=fff;
ccc=ggg;
ddd=hhh;
END;

liion631818

回复 1# linux_caiji

1. awk -v header="APPLICATION_LIST;" -v end="END;" 'NR==1{split($0, keys, ",")}NR>1{print header;split($0, values, ",");for(i in values){print keys[i]"="values[i]";"}; print end;}'

复制代码

moperyblue

1. echo 'aaa,bbb,ccc,ddd
   
2. 111,222,333,444
   
3. 555,666,777,888
   
4. 122,133,144,155'|sed -r '/aaa/{h;d};G;s/(.*)\n(.*)/\2,\n\1/;:a;s/([^,]*),(.*)\n([^,]*),?(.*)/\1=\3;\n\2\n\4/;ta;s/(.*)./APPLICATION_LIST;\n\1END;/'
   
5. APPLICATION_LIST;
   
6. aaa=111;
   
7. bbb=222;
   
8. ccc=333;
   
9. ddd=444;
   
10. END;
    
11. APPLICATION_LIST;
    
12. aaa=555;
    
13. bbb=666;
    
14. ccc=777;
    
15. ddd=888;
    
16. END;
    
17. APPLICATION_LIST;
    
18. aaa=122;
    
19. bbb=133;
    
20. ccc=144;
    
21. ddd=155;
    
22. END;

复制代码

1. awk -F, '/aaa/{split($0,a);next}{print "APPLICATION_LIST;";for(i=1;i<=split($0,b);i++)print a[i]"="b[i]";";print "END;"}'

复制代码

LikeLx

1. awk 'NR==1{l=split($0,a,",");next}{split($0,b,",");print "APPLICATION_LIST;";for(n=0;n++<l;)print a[n]"="b[n];print "END;"}'

复制代码

hz_oracle

awk -F, '/[a-z]/{a=$1;b=$2;c=$3;d=$4;next}{print "APPLICATION_LIST;\n"  a"="$1";\n"b"="$2FS"\n"c"="$3";\n"d"="$4";\nEND;"}' aa.txt

linux_caiji

感谢各位的帮助。