I am normalizing html tables that contain the attribute: rowspan (duplicating and positioning x times).
Each table row, cell is given a multipart line ID...such as 001.001.001
Each rowspan line is duplicated x times and line ID incremented using VBScript
Then the
entire <table> must be sorted
Then line IDs must be reset using VBScript
Then repeat the process (loop) for the next rowspan found.
The problem is that TextPipe can only do work within restrictions all at once...even using variables and 'add section header', etc wont work...because always limited by the restriction.
Here is an example table where the first rowspan is duplicated 3 times and line ID updated.
If we now sort this it would be correct...but with subsequent rowspans they sometimes will be one position off (that is because we are duplicating
all the rowspan's at once and then one sort (it needs to loop so that line IDs may be reset).
I have this all working, but of course the looping part is missing.
This is a very complicated process...the model I have designed works...but just getting TextPipe to do it is challenging
Code: Select all
<table width="500" border="1">
001.001.001 <tr>
001.002.001 <td rowspan="3">a</td>
002.002.000 <td rowspan="3">a</td>
003.002.000 <td rowspan="3">a</td>
001.003.001 <td rowspan="4">c</td>
001.004.001 <td>d</td>
001.005.001 </tr>
002.001.001 <tr>
002.002.001 <td>f</td>
002.003.001 </tr>
003.001.001 <tr>
003.002.001 <td>h</td>
003.003.001 </tr>
004.001.001 <tr>
004.002.001 <td>i</td>
004.003.001 <td>j</td>
004.004.001 </tr>
005.001.001 <tr>
005.002.001 <td>k</td>
005.003.001 <td>l</td>
005.004.001 <td rowspan="3">m</td>
005.005.001 </tr>
006.001.001 <tr>
006.002.001 <td>n</td>
006.003.001 <td>o</td>
006.004.001 </tr>
007.001.001 <tr>
007.002.001 <td>p</td>
007.003.001 <td>q</td>
007.004.001 </tr>
</table>