Issue with AWK

Shell Programming and Scripting
1

I have this input file

 
0FB7,1083,Synchronized,FriNov121655,2816_7RAID5,05F:1_10F:1,10000000NoneNone,DC_db00p01
0FB7,1150,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
06C4,0710,Synchronized,WedMar91105,2816_7RAID5,04E:1_11E:1,10000000NoneNone,DL_nb00p25
06C4,0711,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
0E13,055E,Synchronized,ThuApr141515,2816_7RAID5,N/A,N/A,N/A
0E13,15F2,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
0E12,055D,Synchronized,ThuApr141515,2816_7RAID5,N/A,N/A,N/A
0E12,15F1,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A

I want to combine the lines based on 1st common column ,here's awk code i am using

 
nawk -F"," 'p!=$1{if(NR>1)print s;s=$0;p=$1;next}{s=s","$2","$3","$4","$5","$6","$7","$8 }END{{print s}'

Ouput i am getting

 
0FB7,1083,Synchronized,FriNov121655,2816_7RAID5,05F:1_10F:1,10000000NoneNone,DC_db00p01,1150,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
06C4,0710,Synchronized,WedMar91105,2816_7RAID5,04E:1_11E:1,10000000NoneNone,DL_nb00p25,0711,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
0E13,055E,Synchronized,ThuApr141515,2816_7RAID5,N/A,N/A,N/A,15F2,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A,055D,Synchronized,ThuApr141515,2816_7RAID5,N/A,N/A,N/A,15F1,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A

If you notice ... the output is wrong in case where column 1 is 0E13 OR 0E12

Output i should get

 
0FB7,1083,Synchronized,FriNov121655,2816_7RAID5,05F:1_10F:1,10000000NoneNone,DC_db00p01,1150,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
06C4,0710,Synchronized,WedMar91105,2816_7RAID5,04E:1_11E:1,10000000NoneNone,DL_nb00p25,0711,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
0E13,055E,Synchronized,ThuApr141515,2816_7RAID5,N/A,N/A,N/A,15F2,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A
0E12,055D,Synchronized,ThuApr141515,2816_7RAID5,N/A,N/A,N/A,15F1,Split,MonApr180658,2816_7R5GC,N/A,N/A,N/A

Not sure ... what i am missing ...

2 
nawk -F, '!($1 in a){a[$1]=$0;next} {for(i=2;i<=NF;i++)a[$1]= a[$1] FS $i}END{for(i in a) print a}' myFile
1 Like