Concat one column values in loop bashed on other column

Snehasish · 04-01-2019, 08:06 AM

I am creating a report where i am getting the memory module name and the status of the same. I have written the code to get the HTML file which is giving me output like attached image

Code:

Current OP :
Servername             Module           Status
xxxxxxx                1                3
xxxxxxx                2                3  
xxxxxxx                3                3  
xxxxxxx                5                1  
xxxxxxx                6                1

Below is my code

Code:

FS=","
print "=============================="
printf "<h3>ServerName:%s</h3>", server
print "=============================="
print  "<HTML>""<TABLE border="1">"
}
 {
printf "<TR>"
for(i=1;i<=NF;i++)
{
printf "%s", "<td"
if ($i+0==2) printf " bgcolor=#FF3333"
    else if ($i+0==1) printf " bgcolor=#FFCC33"
    else if ($i+0==4) printf " bgcolor=#99FF33"
print ">" $i "</td>"
}
print "</TR>"
 }
END{
print "</TABLE></BODY></HTML>"
 }
' Report.html

But need the output like all the module with same status should come in comma separated manner in a single row.

Code:

Expected :  
Servername             Module           Status
xxxxxxx                1,2,3            3
xxxxxxx                5,6              1

Please let me know how to achieve this

Turbocapitalist · 04-01-2019, 08:55 AM

You'll have to make one pass through the data and collect all the statuses. Then in the END{} clause, print them out, not before. AWK works quite well for this but perl is much easier in some ways.