Google App Script parse table from messed html

Question

I want to create a script which download html, parse a table and save it to a SpreadSheet. I am stuck on downloading and parsing.

Xpath to table is:

/html/body/table/tbody/tr[5]/td/table/tbody/tr/td[2]/table

Currently I am stuck at parsing Xpath.

function fetchIt() {
var fetchString="http://www.zbranebrymova.com/index.php?s_lev=22&type=nabku*signa"
var response = UrlFetchApp.fetch(fetchString);

var xmlDoc = Xml.parse(response.getBlob().getDataAsString(),true);
var b = xmlDoc.getElement().getElement("body").getElement("table") ;

Logger.log(b);
}

Have a look at http://stackoverflow.com/questions/18241029/why-does-my-xpath-query-scraping-html-tables-only-work-in-firebug-but-not-the regarding `` tags (eg., the outer table definitely does not have any). What about sharing an example spreadsheet document for us to work with (for example, share as read-only URL). By the way, the HTML is so horribly broken that Google Spreasheet's `ImportXML` doesn't even want to parse it. — Jens Erat, Sep 04 '13 at 22:50
Can you be more specific about how you're stuck? The code you showed - does it throw an error? Does it give the wrong result? Does it work ok so far but you just don't know how to get the 5th `` child? — LarsH, Jul 22 '14 at 15:20

score 1 · Answer 1 · answered Dec 16 '13 at 02:44

I don't know if this will be helpful, here is a snippet of my table parsing code:

html file FOO.HTM:

<html>
<head> </head>
<body style="margin-left:10px">
  <table title="">
    <tbody>
      <tr>
        <th align="center" abbr="Sunday">Sun</th>
        <th align="center" abbr="Monday">Mon</th>
      </tr>
      <tr>
        <td align="left"><a title="January 01">1</a>
          <div>Joe,Doe</div>
          <div>Murphy,Jack</div>
        </td>
        <td align="left"><a title="January 02">2</a>
          <div>Carlson,Carl</div>
          <div>Guy,Girl</div>
          <div>Lenin,Vladimir</div>
        </td>
      </tr>
    </tbody>
  </table>
</body>
<html>

and this is how I parse it:

function foo() {
  var page = UrlFetchApp.fetch('foo.htm');
  var rows = Xml.parse(page,true).getElement()
      .getElement("html")
      .getElement("body")
      .getElement("table")
      .getElement("tbody")
      .getElements("tr");

  for (var ii = 0; ii < rows.length; ii++) {
    var cols = rows[ii].getElements("td");
    for (var jj = 0; jj < cols.length; jj++) {
      var divs = cols[jj].getElements("div");
      for (var kk = 0; kk < divs.length; kk++) {
        var div = divs[kk];
      }
    }
  }
}

cheers, sean

Google App Script parse table from messed html

1 Answers1

Linked