html formatting using awk

Shell Programming and Scripting
1

Hi I have a file as given below:

<table border=1>
<TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR>
<TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR>
<TR><TD><CENTER>admin_export.sh</CENTER></TD><TD><CENTER>Locally Modified</CENTER></TD><TD><CENTER>/home/ustst/usstage/src/REPORTS/ADMIN</CENTER></TD></TR>
<TR><TD><CENTER>bid_extract.sh</CENTER></TD><TD><CENTER>Locally Modified</CENTER></TD><TD><CENTER>/home/ustst/usstage/src/REPORTS/BID</CENTER></TD></TR>
<TR><TD><CENTER>Work Area: /home/eatst/</CENTER></TD></TR>
<TR><TD><CENTER>all_validation_ea</CENTER></TD><TD><CENTER>Locally Modified</CENTER></TD><TD><CENTER>/home/eatst/estage/src/EA_FIW/DQ</CENTER></TD></TR>
<TR><TD><CENTER>dc_110b_post.sql</CENTER></TD><TD><CENTER>Needs Checkout</CENTER></TD><TD><CENTER>Not Found</CENTER></TD></TR>

I am using an awk script to get this output:

awk 'BEGIN{
        FS="|"
        print "<HTML><table border=1>"
        print "<TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR>"
     }
     {
        printf "<TR>"
        for(i=1;i<=NF;i++)
        printf "<TD><CENTER>%s</CENTER></TD>", $i
        print "</TR>"
     }
     END{
        print "</TABLE></HTML>"
     }' result_set > report_file.html

When the row has the following input,

<TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR>

the remaining columns appear black. I need to merge the row when the row starts with the pattern 'Work'. Please help

2

Please provide an example of the expected output.