Select specific html with "Html Agility pack"

c# html-agility-pack

Question

I'm using html-agility-pack and trying to select out a specific html in it. The part I want to get is every GTIN-number in these blocks:

<td><span class="mobile-only">GTIN:</span>07330155011068</td>

-The part I want is the numbers after the ending span-tag. Ex: 07330155011068. Below is my html, and my c#-method:

<div class="table-wrapper" style='display: block;'>
    <table id="tableSearchArticle">
        <thead>
            <tr>
                <th><a href="#">Article</a></th>
                <th><a href="#">art.nr.</a></th>
                <th><a href="#">Brand</a></th>
                <th><a href="#">GTIN</a></th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>
                    <a href="http://www.dabas.com/ProductSheet/Detail.ashx/121308" target="_blank">
                        Dalapannkaka fryst ca100st 6kg
                    </a>
                </td>
                <td><span class="mobile-only">Tillverkarens art.nr:</span>11068</td>
                <td><span class="mobile-only">Varumärke:</span>test</td>
                <td><span class="mobile-only">GTIN:</span>07330155011068</td>
            </tr>
            <tr>
                <td>
                    <a href="http://www.dabas.com/ProductSheet/Detail.ashx/124494" target="_blank">
                        Dessertpannkaka fryst ca100st 6kg
                    </a>
                </td>
                <td><span class="mobile-only">Tillverkarens art.nr:</span>11405</td>
                <td><span class="mobile-only">Varumärke:</span>test</td>
                <td><span class="mobile-only">GTIN:</span>07330155114059</td>
            </tr>
        </tbody>
    </table>

    </div>

And I'm using this method to trying to get my values. The problem is I don't know what code to write in the SelectNode() to get the innerHtml containing the GTIN-numbers.

public void TestGetHtml()
    {
        var doc = new HtmlDocument();
        doc.Load("C:/Users/Desktop/test.html");
        foreach (HtmlNode link in doc.DocumentNode.SelectNodes("TODO: Add code to select all GTIN"))
        {

        }
        doc.Save("file.htm");
    }
1
2
8/25/2014 6:30:11 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Use Xpath to select fourth cells from body of table with id tableSearchArticle. Then get inner text of cells (it will be without html tags, like GTIN:07330155114059) and remove GTIN prefix:

var xpath = "//table[@id='tableSearchArticle']/tbody/tr/td[4]";
var gtins = doc.DocumentNode.SelectNodes(xpath)
               .Select(td => td.InnerText.Replace("GTIN:", ""));

Output:

[
  "07330155011068",
  "07330155114059"
]
2
5/23/2014 10:42:48 AM

Popular Answer

SelectNodes receives an Xpath expression. So, you could start with this (untested):

foreach (HtmlNode tr in doc.DocumentNode.SelectNodes(
   "//div[@class='table-wrapper']/table[@id='tableSearchArticle']/tbody/tr"))
{
    Console.WriteLine(tr.InnerHtml);
    Console.WriteLine(tr.SelectSingleNode(".//a").GetAttribute("href"));
    Console.WriteLine(tr.SelectSingleNode(".//td[last()]").InnerText);
}
Rubens Farias

Related Questions

Select nodes following a given node in HTML Agility Pack

using .Class as in Mark's example (if that doesnt exist, substitute whatever is appropriate)...Use ...SkipWhile...e.g. in ...LINQPad... you get ...5,6,7... from:...int[] a = { 6, 5, 6 ,7 }; a.SkipWhile(x=>x!=6).Skip(1).Dump(); ...So depending on the type SelectNodes returns, either:....SelectNodes( "/p" ).SkipWhile( p => p.Class != "specific" ).Ski...
asp.net c# html html-agility-pack
asked by Ruben Bartelink

Get an html fragment from an html document using the Html Agility Pack.

The following will work:...public string GetFragment(HtmlDocument document) { return doc.DocumentNode.SelectSingleNode("//body") == null ? doc.DocumentNode.InnerHtml : doc.DocumentNode.SelectSingleNode("//body").InnerHtml; }
c# html html-agility-pack
asked by Oscar Mederos

With HTML Agility Pack for ASP.NET, how can I delete certain components from HTML? (vb)

This gets you the result you require. This uses Recursive method to drill down all your html nodes and you can simply remove more nodes by adding a new if statment....Public Sub Test() Dim document = New HtmlDocument() With { _ Key .OptionOutputAsXml = True _ } document.LoadHtml("<html><body>I was born in <a name=BC>Toronto</a> ...
asp.net html-agility-pack vb.net
asked by Bobby

How to use HTML Agility Pack to pick a single table cell

Firebug maybe fixed broken html tags. If you want to pick and Html node,it is recommend use class or id. For example:...//div[@class='content']//table//tr[1]/td[2] ...shorten the path,and use class or id selector....if the table has it's own id,you can use:...//table[@id='tableid']/tr[1]/td[2] ...try it,you will find XPATH is interesting.
html-agility-pack vb.net xpath
asked by DennisZhong

How to parse a webresponse and obtain a specific html element in C# using the Html Agility Pack

This console application code:... HtmlDocument doc = new HtmlDocument(); doc.Load(yourHtml); foreach (HtmlNode node in doc.DocumentNode.SelectNodes("//div[@class = 'labels']")) { Console.WriteLine(node.NextSibling.InnerText.Trim()); } ...will output this:...04:28:24 06:04:41
c# html html-agility-pack parsing
asked by Simon Mourier

html agility pack - Select specific node

I believe you want:...HtmlNode selectedNote = html.DocumentNode.SelectSingleNode("//td[@class='formlabel'][text()='Name:']"); ...Or...HtmlNode selectedNote = html.DocumentNode.SelectSingleNode("//td[@class='formlabel'][.='Name:']");
c# html-agility-pack
asked by Chris Gessler

LINQ and HTML Agility Pack filling the parsed HTML table data into a datatable

Given the following ...html...Dim t = <table class='Seller' id='MyTable'> <tr> <th>FooColumn</th> <td>Foo</td> <td>Another Foo</td> </tr> <tr> <th>BarColumn</th> <td>Bar</td> <td>Another Bar</td> </tr> ...
datatable html-agility-pack linq vb.net
asked by sloth

Select HTML from specific position using Html Agility Pack

The ...HtmlNode... class has two important attributes (for what you need to do): ...Line... (the line where the node begins)...LinePosition... (the line where the node ends)...You could do something like:...var nodes = doc.DocumentNode.Descendants("#text").Where( x => (x.Line > 64 || (x.Line == 64 && x.LinePosition >= 45)) && (x.Line <...
c# html html-agility-pack xpath
asked by Oscar Mederos

HTML Agility Pack - Issue selecting an HTML select tag with the option tags within

You need to set the ElementsFlag field for the option tag to make it work...HtmlNode.ElementsFlags["option"] = HtmlElementFlag.Closed; HtmlDocument doc = new HtmlDocument(); doc.LoadHtml(html); ...which should return your original HTML code....I believe the reason that HtmlAgilityPack behaves this way is because the ...<option>...-tag is ...ironic...
.net c# dom html-agility-pack
asked by Daniel B

Strip Specific Styles from the Style attribute in Html string using Html Agility Pack

There doesn't appear to be any support for inline style string parsing in the HTML Agility Pack, but .NET does have some capabilities for this in ...System.Web.UI... to support WebForms controls. ...It's called the ...CssStyleCollection..., and it will convert your ...style... string into a nice array of string key/value pairs, and allow you to rem...
c# html-agility-pack html-parsing
asked by Memetican

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow