Business Objects - PowerInsight

by bmarsh123

HTML

<table class='basic' width='100%' border='0'>
  <tr>
    <td align='left'><b>1/1785</b></td>
    <td align='right'><a href='#top-anchor'>top</a></td>
  </tr>
</table>
<table class='basic' width='100%' border='1' cellspacing='0'>
  <tr class='header'>
    <td valign='top' colspan=2 width='15%' class='sectionHeader'>Properties</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_ID</td>
    <td valign='top'>18</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_NAME</td>
    <td valign='top'>User Folders</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_PARENTID</td>
    <td valign='top'>0</td>
  </tr>
</table>
<br>
<br>
<table class='basic' width='100%' border='0'>
  <tr>
    <td align='left'><b>2/1785</b></td>
    <td align='right'><a href='#top-anchor'>top</a></td>
  </tr>
</table>
<table class='basic' width='100%' border='1' cellspacing='0'>
  <tr class='header'>
    <td valign='top' colspan=2 width='15%' class='sectionHeader'>Properties</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_ID</td>
    <td valign='top'>23</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_NAME</td>
    <td valign='top'>Root Folder</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_PARENTID</td>
    <td valign='top'>4</td>
  </tr>
</table>
<br>
<br>
<table class='basic' width='100%' border='0'>
  <tr>
    <td align='left'><b>3/1785</b></td>
    <td align='right'><a href='#top-anchor'>top</a></td>
  </tr>
</table>
<table class='basic' width='100%' border='1' cellspacing='0'>
  <tr class='header'>
    <td valign='top' colspan=2 width='15%' class='sectionHeader'>Properties</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_ID</td>
    <td valign='top'>45</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_NAME</td>
    <td valign='top'>Categories</td>
  </tr>
  <tr>
    <td valign='top' width='15%'>SI_PARENTID</td>
    <td valign='top'>4</td>
  </tr>
</table>
<br>
<br>
<table class='basic' width='100%' border='0'>
  <tr>
    <td...

JavaScript

$(function() {
  var tblRow = $('.basic').find('tr:nth-child(1)');
  var tblRow1 = $('.header').remove();
  tblRow.remove();
  tblRow1.remove();

  var table = $('<table width="100%" border="1" cellspacing="0"></table>').addClass('foo');
  var headRow = $('<tr><td>Report Title</td><td>ID</td><td>Parent ID</td></tr>').addClass('bar');
  table.append(headRow);

  $('.basic').each(function() {

    var siID = $(this).find('tr:nth-child(1) td:nth-child(2)').html();
    var siTitle = $(this).find('tr:nth-child(2) td:nth-child(2)').html();
    var siParent = $(this).find('tr:nth-child(3) td:nth-child(2)').html();
    var row = $('<tr><td>' + siTitle + '</td><td>' + siID + '</td><td>' + siParent + '</td></tr>');
    if (siTitle) {
      table.append(row);
    }

  });

  $('.basic').remove();
  $('body').prepend(table);
});