StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Please try the following. You might also consider pulling the table apart as it is a little better formed than the free-text in the 'p' tag.</p> <p>Cheers, Aaron.</p> <pre><code>// download the site content and create a new html document // NOTE: make this asynchronous etc when considering IO performance var url = "http://explorer.litecoin.net/address/Li7x5UZqWUy7o1tEC2x5o6cNsn2bmDxA2N"; var data = new WebClient().DownloadString(url); var doc = new HtmlDocument(); doc.LoadHtml(data); // extract the transactions 'h3' title, the node we want is directly before it var transTitle = (from h3 in doc.DocumentNode.Descendants("h3") where h3.InnerText.ToLower() == "transactions" select h3).FirstOrDefault(); // tokenise the summary, one line per 'br' element, split each line by the ':' symbol var summary = transTitle.PreviousSibling.PreviousSibling; var tokens = (from row in summary.InnerHtml.Replace("<br>", "|").Split('|') where !string.IsNullOrEmpty(row.Trim()) let line = row.Trim().Split(':') where line.Length == 2 select new { name = line[0].Trim(), value = line[1].Trim() }); // using linqpad to debug, the dump command drops the currect variable to the output tokens.Dump(); </code></pre> <p>'Dump()', is a LinqPad command that dumps the variable to the console, the following is a sample of the output from the Dump command:</p> <ul> <li>Balance: 5 LTC</li> <li>Transactions in: 2</li> <li>Received: 5 LTC</li> <li>Transactions out: 0</li> <li>Sent: 0 LTC</li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload