Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concat one column values in loop bashed on other column

Status
Not open for further replies.

SnehasishNandy

Programmer
Dec 3, 2018
1
0
0
IN
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
below is the code
Bash:
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
 
 https://files.engineering.com/getfile.aspx?folder=a1dcf08a-f614-481b-a2a2-6d6c05368f88&file=Capture.JPG
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top