Jump to content
Sign in to follow this  
sammy1983

table data inside another table data

Recommended Posts

sammy1983

Hi,

Please look at the screenshot taken from the internal tool source code. I am trying to extract "Investments" from the below source code.

<td align="LEFT">Investments&nbsp;</td>

Below is my code:

$sHTML = _IEDocReadHTML($oIE1)
$array = StringRegExp($sHTML, '(?i)">(.*?)</(?i)td>', 3)
For $a = 0 To UBound($array) - 1
    $Date = $array[$a]
    MsgBox(0, "", $Date)
Next

but the above code extracts just "10021" and then "State Employees CU (NC) (Member View) - Investments" and then moves to the second row in the table without moving to the next element. It seems that because <td>... </td> is closed script is not moving to next element.

 

post-80752-0-78824000-1396120162_thumb.j

Share this post


Link to post
Share on other sites
mikell

If the text is really the same than in the image then the code should work

$str = '<td align="LEFT">Finance&nbsp;</td>' & @crlf & _
    '<td align="LEFT">Investments&nbsp;</td>' & @crlf & _
    '<td align="LEFT">7868&nbsp;</td>' 

$array = StringRegExp($str, '(?i)">(.*?)</td>', 3)
For $a = 0 To UBound($array) - 1
    $Date = $array[$a]
    MsgBox(0, "", $Date)
Next

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×