Help with RegEx for decimal numbers

[skhoury]

Hello all...I've attempted to parse the following piece of HTML table for decimal numbers with limited luck. So far, i've gotten my RegEx to extract decimal numbers but I can't get it to recognize the value ".286792" below. Likewise, it is also capturing the "W. TF" because it has a "." in it.

Here is my expression so far...
\(?[0-9]{0,3}\.[0-9]{0,7}\)?

Any thoughts on what I am missing so far?

Thanks all,

Sam

<tr>
<td valign="top" align="left" bgcolor="#FFFFCC" class="ArticlePagesBodycopyReg" width="38%">W. TF</td> <td bgcolor="#FFFFCC" width="2%">&nbsp;</td>
<td valign="top" align="right" bgcolor="#FFFFCC" class="ArticlePagesBodycopyReg" width="18%">.286792</td> <td bgcolor="#FFFFCC" width="2%">&nbsp;</td>
<td valign="top" align="right" bgcolor="#FFFFCC" class="ArticlePagesBodycopyReg" width="13%">(0.022222)</td> <td bgcolor="#FFFFCC" width="2%">&nbsp;</td>
<td valign="top" align="center" bgcolor="#FFFFCC" class="ArticlePagesBodycopyReg" width="13%">0.16</td>
<td bgcolor="#FFFFCC" width="2%">&nbsp;</td>
<td valign="top" align="center" bgcolor="#FFFFCC" class="ArticlePagesBodycopyReg" width="10%">8.87</td>
</tr>

 

[BoulderBum]

Your expression thinks capturing only a period is okay. You'll want to require numbers on one side or the other.

This will work:

\(?(?:\d{1,3}\.\d{0,7}|\d{0,3}\.\d{1,7})\)?

 

[skhoury]

Perfect - it works. Thanks!

Sam