I have dozens of these kind of file from a client that I need to store in the database as separate columns and other important identifier information.
How can I extract the Question: What is the color of Orange and 4 response options for it? I also want to extract all information from the "key" node with values in the ID, EVAL attribute as well.
<TestItem CLASS="MOAT" METHOD="Multiple">
<div id="stim" style="width:455px;text-align:center;margin:10px 10px 10px 0px;height:580px;background-color:#ffffff;padding:10px;">
<div style=" margin:10px; text-align:center;background-color:#ffffff;">
<table>
<tr>
<td valign="middle" align="right">
<img src="../images/test1/test1.jpg" />
</td>
<td valign="middle" align="left">
<div class="inItemEnclosedbubble">
What is the color of Orange?
</div>
</td>
</tr>
</table>
<br/>
<br/>
<div style="text-align:left;margin:auto;">