Looking for: Parse rows from HTML table

AutoHotkey Community
Let's help each other out

FAQ

Memberlist

Profile

Looking for: Parse rows from HTML table
Goto page Previous 1, 2, 3 Next

AutoHotkey Community Forum Index -> Ask for Help

View previous topic :: View next topic

Author

Message

jethrow

Joined: 24 May 2009
Posts: 970
Location: Iowa, USA

Posted: Mon Feb 08, 2010 5:57 pm Post subject:

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

_________________
Mr. Green

- in case I forgot to smile
AutoHotkey_L, COM_L, Webpage Controls

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 7:12 pm Post subject:

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....

Guest

Posted: Mon Feb 08, 2010 7:16 pm Post subject:

Please provide the HTML.

sinkfaze

Joined: 19 Mar 2008
Posts: 3266
Location: the tunnel(?=light)

Posted: Mon Feb 08, 2010 7:32 pm Post subject:

He provided a sample of it here. _________________ Try Quick Search for Autohotkey or see the tutorial for newbies.

knat

Joined: 21 Dec 2007
Posts: 2878
Location: Louisville KY USA

Posted: Mon Feb 08, 2010 7:48 pm Post subject:

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

_________________
"Lest we forget Pre Nazi Germany was a Democracy"

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 7:56 pm Post subject:

tank wrote:

what about

Code:

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

Guest

Posted: Mon Feb 08, 2010 8:58 pm Post subject:

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

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 9:08 pm Post subject:

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>T3h Customer / 901094</td><td nowrap align="center">1403</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.7</td><td nowrap align="center">4.6</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap></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>T3h Customer / 901094</td><td nowrap align="center">1403</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.7</td><td nowrap align="center">4.6</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap></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>T3h Customer / 901094</td><td nowrap align="center">1403</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.7</td><td nowrap align="center">4.6</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap></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>T3h Customer / 901094</td><td nowrap align="center">1403</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.6</td><td nowrap align="center">4.7</td><td nowrap align="center">4.6</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap align="center">0.0</td><td nowrap></td><td><img src="/icons/ecblank.gif" border="0" height="16" width="1" alt=""></td></tr></TD>
</TR>

</TABLE>

Guest

Posted: Mon Feb 08, 2010 9:36 pm Post subject:

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

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 10:14 pm Post subject:

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>

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

n-l-i-d
Guest

Posted: Mon Feb 08, 2010 11:06 pm Post subject:

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

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 11:09 pm Post subject:

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.

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 11:21 pm Post subject:

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 Mon Feb 08, 2010 11:24 pm; edited 1 time in total

jethrow

Joined: 24 May 2009
Posts: 970
Location: Iowa, USA

Posted: Mon Feb 08, 2010 11:24 pm Post subject:

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

_________________
Mr. Green

- in case I forgot to smile
AutoHotkey_L, COM_L, Webpage Controls

randallf

Joined: 06 Jul 2009
Posts: 579

Posted: Mon Feb 08, 2010 11:27 pm Post subject:

jethrow wrote:

Try this:

Code:

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!!!

Display posts from previous:

	AutoHotkey Community Forum Index -> Ask for Help	All times are GMT Goto page Previous 1, 2, 3 Next
Page 2 of 3

You can post new topics in this forum
You can reply to topics in this forum