Data with multiple delimiters

[jerry898969]

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.

[Reeza]

Try googling with the search terms : SAS IMPORT HTML TABLE

There are a few papers and references that look promising, as well as a suggestion to use XML processing.