carlo.m

Converting text array to html format for table

Discussion created by carlo.m on Sep 28, 2012
Latest reply on Oct 1, 2012 by steve_ssh

I have an array of text (comma dilmited data return delimted rows) that I want to display on an html table with webviewer.

 

 

As of now, I have an array with the following rows as headers:

 

Category, Part, Week 30, Week 30, Week 31, Week 31, Week 32, Week 32

Category, Part, Sales, Units, Sales, Units, Sales, Units

 

With a Custom Function, I would like to convert it to:

 

 

<tr>

<th rowspan="2"> Category </th>

<th rowspan="2"> Part </th>

<th colspan="2"> Week 30 </th>

<th colspan="2"> Week 31 </th>

<th colspan="2"> Week 32</th>

</tr>

<tr>

<th> sales </th>

<th> units </th>

<th> sales </th>

<th> units </th>

<th> sales </th>

<th> units </th>

</tr>

 

 

ANY IDEAS????

Outcomes