View topic - Looking for: Parse rows from HTML table • AutoHotkey Community

View unanswered posts | View active topics

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Looking for: Parse rows from HTML table

Page 2 of 3

[ 36 posts ]

Go to page Previous 1, 2, 3 Next

Print view | E-mail friend

Previous topic | Next topic

Author

Message

jethrow

Post subject:

Posted: February 8th, 2010, 5:57 pm

Joined: May 24th, 2009, 5:35 am
Posts: 2099
Location: Iowa, USA

How about:

Code:

html =
(
; enter html here
)

row := "" 
doc := COM_CreateObject( "HTMLfile" ) 
doc.write( html ) 
Loop, % ( td:=doc.all.tags( "td" ) ).length 
   If ( text:=td[ A_Index-1 ].innerText ) <> "" 
      row .= ( text+0="" ? ( row="" ? "" : "`n" ) text : text "`t" )
MsgBox, % RTrim( row )
Return

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

Top

randallf

Post subject:

Posted: February 8th, 2010, 7:12 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

That does sortof work, however I have lines with %'s on them that it also adds an 'n for... really this needs to be finding </TR> for these documents, if that's at all possible....

Top

Guest

Post subject:

Posted: February 8th, 2010, 7:16 pm

Please provide the HTML.

Top

sinkfaze

Post subject:

Posted: February 8th, 2010, 7:32 pm

Joined: March 19th, 2008, 12:43 am
Posts: 5480
Location: the tunnel(?=light)

He provided a sample of it here.

_________________

Try Quick Search for Autohotkey or see the tutorial for newbies.

Top

tank

Post subject:

Posted: February 8th, 2010, 7:48 pm

Joined: December 21st, 2007, 3:14 pm
Posts: 3826
Location: Louisville KY USA

what about

Code:

html =
(
; enter html here
)

row := ""
doc := COM_CreateObject( "HTMLfile" )
doc.write( html )
Loop, % ( tr:=doc.all.tags( "tr" ) ).length
{
   Loop, % ( td:=tr.cells ).length
        row .=  td[ A_Index-1 ].innerText
   row .= "`n"     
)
        
MsgBox, % RTrim( row )
Return

untested
to get anything into the clipboard

Code:

clipboard=
clipboard:=ahk expression here
clipwait
;; paste away from here

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

Top

randallf

Post subject:

Posted: February 8th, 2010, 7:56 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

tank wrote:

what about

Code:

html =
(
; enter html here
)

row := ""
doc := COM_CreateObject( "HTMLfile" )
doc.write( html )
Loop, % ( tr:=doc.all.tags( "tr" ) ).length
{
   Loop, % ( td:=tr.cells ).length
        row .=  td[ A_Index-1 ].innerText
   row .= "`n"     
)
        
MsgBox, % RTrim( row )
Return

untested
to get anything into the clipboard

Code:

clipboard=
clipboard:=ahk expression here
clipwait
;; paste away from here

I tried but not sure what to correct,

Quote:

>"E:\FSROOT\PORTABLE\AutoHotkey\SciTE\..\AutoHotkey_L.exe" /ErrorStdOut "moretest.ahk"
E:\FSROOT\FILES\SCRIPTS\AutoHotKey\Automation\moretest.ahk (17) : ==> This line does not contain a recognized action.
Specifically: )
>Exit code: 2 Time: 0.232

Top

Guest

Post subject:

Posted: February 8th, 2010, 8:58 pm

sinkfaze wrote:

He provided a sample of it here.

Not of a table with multiple rows - which is what he is now asking about :wink:

Top

randallf

Post subject:

Posted: February 8th, 2010, 9:08 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

Anonymous wrote:

sinkfaze wrote:

He provided a sample of it here.

Not of a table with multiple rows - which is what he is now asking about :wink:

Same deal, only repeated, (which is what I did here) sorry but I have to be careful with this data, can't just put wherever... there is also a header row that comes before this but that doesn't seem to have been the problem thus far and is similarly encoded.

Code:

<TABLE>
<table border="0" cellpadding="2" cellspacing="0">
  <TD><tr valign="top" bgcolor="#E0F1FF"><td nowrap><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td><td colspan="5" nowrap><a href="/survey_t3hwebsite.nsf/*1-SurveysGroupTrendHC?OpenPage&Start=1&Count=30&Collapse=1.1" target="_self"><img src="/icons/collapse.gif" border="0" height="16" width="16" alt="Hide details for T3h Customer / 901094"></a><font size="2" color="#0000ff" face="Arial">T3h Customer / 901094</font></td><td nowrap align="center"><b><font size="2" color="#000000" face="Arial">1403</font></b></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.7</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap><font size="2" face="Arial"></font></td><td><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td></tr></TD>
</TR>

<TR>
  <TD><tr valign="top" bgcolor="#E0F1FF"><td nowrap><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td><td colspan="5" nowrap><a href="/survey_t3hwebsite.nsf/*1-SurveysGroupTrendHC?OpenPage&Start=1&Count=30&Collapse=1.1" target="_self"><img src="/icons/collapse.gif" border="0" height="16" width="16" alt="Hide details for T3h Customer / 901094"></a><font size="2" color="#0000ff" face="Arial">T3h Customer / 901094</font></td><td nowrap align="center"><b><font size="2" color="#000000" face="Arial">1403</font></b></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.7</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap><font size="2" face="Arial"></font></td><td><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td></tr></TD>
</TR>

<TR>
  <TD><tr valign="top" bgcolor="#E0F1FF"><td nowrap><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td><td colspan="5" nowrap><a href="/survey_t3hwebsite.nsf/*1-SurveysGroupTrendHC?OpenPage&Start=1&Count=30&Collapse=1.1" target="_self"><img src="/icons/collapse.gif" border="0" height="16" width="16" alt="Hide details for T3h Customer / 901094"></a><font size="2" color="#0000ff" face="Arial">T3h Customer / 901094</font></td><td nowrap align="center"><b><font size="2" color="#000000" face="Arial">1403</font></b></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.7</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap><font size="2" face="Arial"></font></td><td><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td></tr></TD>
</TR>

<TR>
  <TD><tr valign="top" bgcolor="#E0F1FF"><td nowrap><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td><td colspan="5" nowrap><a href="/survey_t3hwebsite.nsf/*1-SurveysGroupTrendHC?OpenPage&Start=1&Count=30&Collapse=1.1" target="_self"><img src="/icons/collapse.gif" border="0" height="16" width="16" alt="Hide details for T3h Customer / 901094"></a><font size="2" color="#0000ff" face="Arial">T3h Customer / 901094</font></td><td nowrap align="center"><b><font size="2" color="#000000" face="Arial">1403</font></b></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.7</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">4.6</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap align="center"><font size="2" color="#000000" face="Arial">0.0</font></td><td nowrap><font size="2" face="Arial"></font></td><td><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td></tr></TD>
</TR>

</TABLE>

Top

Guest

Post subject:

Posted: February 8th, 2010, 9:36 pm

Here's an example:

Code:

html =
(
   ; place html here
)

data := "" 
doc := COM_CreateObject( "HTMLfile" ) 
doc.write( html )
Loop, % ( rows := doc.all.tags( "tr" ) ).length
   If ( rows[ A_Index-1 ].innerText <> "" )
      Loop, % ( item:=rows[ A_Index-1 ].all.tags( "td" ) ).length {
         If ( text:=item[ A_Index-1 ].innerText ) <> ""
            data .= text "`t"
      }
   Else, data .= data ? "`n" : ""
MsgBox, %data%
Return

Top

randallf

Post subject:

Posted: February 8th, 2010, 10:14 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

Thank you so much, Guest, that worked great for the example that I gave you!

Unfortunately it doesn't work right for the text as it's grabbed by the function:

Code:

url:="URL"
pwb := COM_CreateObject("InternetExplorer.Application")
pwb.Visible := False
pwb.Navigate(url)
Loop
  if (pwb.readyState = 4) ; wait for page to load
    break
html := pwb.document.documentElement.outerHTML ; should be correct to get the source

Here's the actual (edited) text... everything I plan to grab is at least similar to this... is there a change that can be made so it will parse correctly?

Code:

<HTML><HEAD>
<SCRIPT language=JavaScript type=text/javascript>
<!-- 
document._domino_target = "_self";
function _doClick(v, o, t) {
  var returnValue = false;
  var url="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&Start=1&Count=1000&Expand=1%2C%20test.html&Click=" + v;
  if (o.href != null) {
    o.href = url;
    returnValue = true;
  } else {
    if (t == null)
      t = document._domino_target;
    window.open(url, t);
  }
  return returnValue;
}
// -->
</SCRIPT>
</HEAD>
<BODY text=#000000 bgColor=#ffffff>
<FORM action=""><B><FONT face=Arial color=#000080>something</FONT></B> 
<TABLE cellSpacing=0 cellPadding=2 border=0>
<TBODY>
<TR>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header1</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header2</FONT></TH>
<TH noWrap align=left><FONT face=Arial size=2>Month</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header3</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header4</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=left><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=right><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=right><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=right><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=right><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=right><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH noWrap align=right><FONT face="Arial Narrow" size=2>header</FONT></TH>
<TH></TH></TR>
<TR vAlign=top>
<TD noWrap colSpan=4><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Collapse=1" target=_self><IMG height=16 alt="Hide details for workplace stuff Diagnostics / 901094" src="/icons/collapse.gif" width=16 border=0></A><B><FONT face=Arial color=#000080 size=2>workplace stuff Diagnostics / 901094</FONT></B></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>51</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>530</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>662</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4144</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1281</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>541</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>46%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>7196</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>63%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>37%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>34%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>66%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.1" target=_self><IMG height=16 alt="Show details for a-stuff" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>a-stuff</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>3</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>9</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>29</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>202</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>79</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>43</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>5%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>367</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>59%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>41%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>27%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>73%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.2" target=_self><IMG height=16 alt="Show details for a-stuff" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>a-stuff</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>6</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>43</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>1%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>52</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>85%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>15%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.3" target=_self><IMG height=16 alt="Show details for FIELD" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>FIELD</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>6</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>41</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>5</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>1%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>59</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>76%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>24%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>42%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>58%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.4" target=_self><IMG height=16 alt="Show details for peoples - San Francisco" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>peoples - San Francisco</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.5" target=_self><IMG height=16 alt="Show details for ssssss" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>ssssss</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>4</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.6" target=_self><IMG height=16 alt="Show details for ssssss" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>ssssss</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>58</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>131</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1035</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>185</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>56</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>20%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>1469</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>79%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>21%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>65%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>35%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.7" target=_self><IMG height=16 alt="Show details for workplace - asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>workplace - asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>12</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>185</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>27</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>16</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>3%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>241</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>82%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>18%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>41%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>59%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.8" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>22</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>22</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.9" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>42</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>40</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>224</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>36</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>130</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>7%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>474</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>50%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>50%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>45%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.10" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>6</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>31</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>53</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>239</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>57</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>5%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>383</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>41%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>59%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>14%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>86%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.11" target=_self><IMG height=16 alt="Show details for asdfasdf, NJ" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf, NJ</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>13</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>30</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>293</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>53</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>65</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>6%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>456</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>63%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>37%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.12" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>3</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>7</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>40</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>216</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>4%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>269</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>75%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>25%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.13" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>109</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>2%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>111</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>2%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>98%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.14" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>5</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>7</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>86%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>14%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.15" target=_self><IMG height=16 alt="Show details for asdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>11</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>36</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>128</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>684</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>283</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>63</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>17%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>1202</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>64%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>36%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>39%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>61%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.16" target=_self><IMG height=16 alt="Show details for asdfasdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>6</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>18</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>110</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>333</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>49</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>34</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>8%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>546</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>57%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>43%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.17" target=_self><IMG height=16 alt="Show details for asdfasdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>13</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>100</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>2%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>113</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>87%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>13%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.18" target=_self><IMG height=16 alt="Show details for asdfasdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfasdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>254</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>11</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>39</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>123</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>13</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>6%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>444</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>9%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>91%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>45%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.19" target=_self><IMG height=16 alt="Show details for asdfzdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfzdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>18</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>49</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>14</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>1%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>82</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>82%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>18%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>18%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>82%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.20" target=_self><IMG height=16 alt="Show details for asdfzdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfzdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>3</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>77</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>62</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>574</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>13</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>38</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>11%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>767</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>76%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>24%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>9%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>91%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.21" target=_self><IMG height=16 alt="Show details for asdfzdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfzdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>15</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>93</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>2%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>108</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>86%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>14%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>98%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>2%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.22" target=_self><IMG height=16 alt="Show details for asdfzdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfzdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>8</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>9</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap colSpan=3><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=1.23" target=_self><IMG height=16 alt="Show details for asdfzdfasdf" src="/icons/expand.gif" width=16 border=0></A><FONT face=Arial color=#0000ff size=2>asdfzdfasdf</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>7</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>10</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>0%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>90%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>10%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap colSpan=4><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=2" target=_self><IMG height=16 alt="Show details for workplace asdfzdfasdf / 400049" src="/icons/expand.gif" width=16 border=0></A><B><FONT face=Arial color=#000080 size=2>workplace asdfzdfasdf / 400049</FONT></B></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>12</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>102</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>52</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>413</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>89</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>85</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>5%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>750</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>45%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>64%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>36%</FONT></TD>
<TD></TD></TR>
<TR vAlign=top bgColor=#e0f1ff>
<TD noWrap colSpan=4><A href="/mm_logstuffbookthing.nsf/*6-asdfzdfasdf?OpenPage&amp;Start=1&amp;Count=1000&amp;Expand=3" target=_self><IMG height=16 alt="Show details for workplace asdfzdfasdf" src="/icons/expand.gif" width=16 border=0></A><B><FONT face=Arial color=#000080 size=2>workplace asdfzdfasdf</FONT></B></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>57</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>941</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>661</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>4396</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1378</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>117</FONT></TD>
<TD noWrap><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>49%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>7544</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>62%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>38%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>57%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>43%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR>
<TR vAlign=top>
<TD noWrap colSpan=4></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>120</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>0</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1573</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>1375</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>8953</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>2748</FONT></TD>
<TD noWrap><FONT face=Arial color=#000000 size=2>743</FONT></TD>
<TD noWrap></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>55%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>15490</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>62%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>38%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>47%</FONT></TD>
<TD noWrap align=right><FONT face=Arial color=#000000 size=2>53%</FONT></TD>
<TD><IMG height=16 alt="" src="/icons/ecblank.gif" width=1 border=0></TD></TR></TBODY></TABLE></FORM></BODY></HTML>

Top

n-l-i-d

Post subject:

Posted: February 8th, 2010, 11:06 pm

Guest's code works just fine with the new example html.

Top

randallf

Post subject:

Posted: February 8th, 2010, 11:09 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

n-l-i-d wrote:

Guest's code works just fine with the new example html.

Really? I wonder what I'm doing wrong, I'll have to test some more.

Top

randallf

Post subject:

Posted: February 8th, 2010, 11:21 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

n-l-i-d wrote:

Guest's code works just fine with the new example html.

Any chance that you could share the script that worked? I is perplexed D:

Last edited by randallf on February 8th, 2010, 11:24 pm, edited 1 time in total.

Top

jethrow

Post subject:

Posted: February 8th, 2010, 11:24 pm

Joined: May 24th, 2009, 5:35 am
Posts: 2099
Location: Iowa, USA

Try this:

Code:

html =
(
   ; enter HTML here
)

data := "" 
doc := COM_CreateObject( "HTMLfile" ) 
doc.write( html )
table := doc.all.tags( "table" )

Loop, % ( rows := table[0].all.tags( "tr" ) ).length {
   If ( rows[ A_Index-1 ].innerText <> "" )
      Loop, % ( item:=rows[ A_Index-1 ].all.tags( "td" ) ).length
         If ( text:=item[ A_Index-1 ].innerText ) <> ""
            If RegExMatch( data, "`n$" ) && ( text+0<>"" )
               data .= "`t" text "`t"
            Else data .= text "`t"
   data .= data ? "`n" : ""
}
MsgBox, %data%
FileAppend, %data%, text.txt
Return

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

Top

randallf

Post subject:

Posted: February 8th, 2010, 11:27 pm

Joined: July 6th, 2009, 9:58 pm
Posts: 678

jethrow wrote:

Try this:

Code:

html =
(
   ; enter HTML here
)

data := "" 
doc := COM_CreateObject( "HTMLfile" ) 
doc.write( html )
table := doc.all.tags( "table" )

Loop, % ( rows := table[0].all.tags( "tr" ) ).length {
   If ( rows[ A_Index-1 ].innerText <> "" )
      Loop, % ( item:=rows[ A_Index-1 ].all.tags( "td" ) ).length
         If ( text:=item[ A_Index-1 ].innerText ) <> ""
            If RegExMatch( data, "`n$" ) && ( text+0<>"" )
               data .= "`t" text "`t"
            Else data .= text "`t"
   data .= data ? "`n" : ""
}
MsgBox, %data%
FileAppend, %data%, text.txt
Return

This is the stuff. Gorgeous, thank you SO much, the only additional modification would be to have it also return the header row from the top.

This is going to kick off some really great stuff, thanks again for your time!!!

Top

Page 2 of 3

[ 36 posts ]

Go to page Previous 1, 2, 3 Next

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Who is online

Users browsing this forum: Alpha Bravo, Google [Bot], LazyMan, rbrtryn and 24 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum