I have a text file I have to import. This file contains an id field and then html.
0000001^<tr><td>TEST1</td><td>01/01/01</td><td>FRANK</td></tr><tr><td>TEST2</td><td>01/02/01</td><td>DAVE</td></tr>
0000002^<tr><td>TEST1</td><td> </td><td>WILL</td></tr>
0000003^<tr><td>TEST1</td><td>02/11/12</td><td>JIM</td></tr><tr><td>TEST2</td><td>02/12/13</td><td>Greg</td></tr><tr><td>TEST3</td><td> </td><td> </td></tr>
I need to create a data file that will parse each row and create a multiple rows for every <tr></tr> combination. Based on the above data the results should be
ID
0000001 TEST1 01/01/01 FRANK
0000001 TEST2 01/02/01 DAVE
0000002 TEST1 WILL
0000003 TEST1 02/11/12 JIM
0000003 TEST2 02/12/13 Greg
0000003 TEST3
Thank you for any help.