Hi,
I am trying to find a extract the dates found in the below raw data, and post them one at a time... there will only be a maximum of two of these dates per row.
I got some help yesterday extracting the 5 digit numbers, so im not sure if that can be changed or not, but let me know and ill post that code if needed.
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>A</b></td><td align="center" bgcolor="#C0C0C0"><b>B</b></td><td align="center" bgcolor="#C0C0C0"><b>C</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>1</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Results </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Result </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">abc.k(p).nov20.99375.65487.12354.jan13.p </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">nov20 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jan13 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">edf.jun20.99815.p </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jun20 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>4</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">abc.s.jan40.65841 </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jan40 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>5</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">tge.s.96514.jan15.96548.Feb15 </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jan15 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">feb15 </font></td></tr>
</table>
thanks in advnace for any help
I am trying to find a extract the dates found in the below raw data, and post them one at a time... there will only be a maximum of two of these dates per row.
I got some help yesterday extracting the 5 digit numbers, so im not sure if that can be changed or not, but let me know and ill post that code if needed.
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>A</b></td><td align="center" bgcolor="#C0C0C0"><b>B</b></td><td align="center" bgcolor="#C0C0C0"><b>C</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>1</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Results </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Result </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">abc.k(p).nov20.99375.65487.12354.jan13.p </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">nov20 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jan13 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">edf.jun20.99815.p </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jun20 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>4</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">abc.s.jan40.65841 </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jan40 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>5</b></td><td rowspan="1" colspan="1" width="493.5" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">tge.s.96514.jan15.96548.Feb15 </font></td><td rowspan="1" colspan="1" width="151.5" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">jan15 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">feb15 </font></td></tr>
</table>
thanks in advnace for any help