I have a download from by HR system but I'm having problems getting the data into a format for the report I have to generate.
I want a report that looks like the following...
<tbody>
</tbody>
The data that I have looks like this...
<tbody></tbody>
<colgroup><col width="209"><col width="198" span="3"><col width="90"><col width="198"></colgroup><tbody>
</tbody>
What is the easiest way to compress this data to one line per employee?
I want a report that looks like the following...
Employee Name | Medical | Dental | Vision | Vision Pay | Flex |
Emp1 | MedBasicFamily | DenBasicFam | Vision | $18.00 | Flex |
Emp2 | MedBasicSingle | Vision | $8.50 |
<tbody>
</tbody>
The data that I have looks like this...
<tbody></tbody>
<tbody> </tbody> |
<colgroup><col width="209"><col width="198" span="3"><col width="90"><col width="198"></colgroup><tbody>
</tbody>
What is the easiest way to compress this data to one line per employee?