Re: Convert a database file to Html format

John,

if you have BASH you can try with something like this:

echo "<table>" ;
print_header=true
while read INPUT ; do
if $print_header;then
echo "<tr><th>$INPUT" | sed -e 's/:[^,]*\(,\|$\)/<\/th><th>/g'
print_header=false
fi
echo "<tr><td>${INPUT//,/</td><td>}</td></tr>" ;
done < cpuwaitovr.csv ;
echo "</table>"

or an even/odd lines report:


echo "<style type='text/css'>
.tg {border-collapse:collapse;border-spacing:0;border-color:#999;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px
5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#999;color:#444;background-color:#F7FDFA;}
.tg th{font-family:Arial,
sans-serif;font-size:14px;font-weight:normal;padding:10px
5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#999;color:#fff;background-color:#26ADE4;}
.tg .tg-yw4l{vertical-align:top}
.tg .tg-6k2t{background-color:#D2E4FC;vertical-align:top}
</style>
<table class='tg'>
<tr>
<th class='tg-yw4l'>Interval</th>
<th class='tg-yw4l'>Date-Time</th>
<th class='tg-yw4l'>CPU Utilization</th>
<th class='tg-yw4l'>Dispatched CPU</th>
<th class='tg-yw4l'>Queuing</th>
<th class='tg-yw4l'>Disk Time</th>
<th class='tg-yw4l'>Journaling</th>
<th class='tg-yw4l'>OS Contention</th>
<th class='tg-yw4l'>Lock Contention</th>
<th class='tg-yw4l'>Inelegible Waits</th>
</tr>";
even=true;
while read INPUT ; do
if $even;then
echo "<tr><td class='tg-6k2t'>${INPUT//,/</td><td
class='tg-6k2t'>}</td></tr>"
even=false
fi
if ! $even;then
echo "<tr><td class='tg-yw4l'>${INPUT//,/</td><td
class='tg-yw4l'>}</td></tr>"
even=true
fi
done < cpuwaitovr.csv ;
echo "</table>"



Good luck<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table
style="border-top: 1px solid #D3D4DE;">
<tr>
<td style="width: 55px; padding-top: 18px;"><a
href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail";
target="_blank"><img
src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png";
alt="" width="46" height="29" style="width: 46px; height: 29px;"
/></a></td>
<td style="width: 470px; padding-top: 17px; color: #41424e;
font-size: 13px; font-family: Arial, Helvetica, sans-serif;
line-height: 18px;">Libre de virus. <a
href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail";
target="_blank" style="color: #4453ea;">www.avg.com</a> </td>
</tr>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>