JSoup how to parse table 3 rows

Question

I have a table like this that i want to Parse to get the data-code value of row.id and the second and third column of the table.

<table>
    <tr class="id" data-code="100">
       <td></td>
       <td>18</td>
       <td class="name">John</td>
    <tr/>
    <tr class="id" data-code="200">
       <td></td>
       <td>21</td>
       <td class="name">Mark</td>
    <tr/>
</table>

I want to print out.

100, 18, John
200, 21, Mark

I have tried the following suggestion from this thread but its not selecting anything how to parse a table from HTML using jsoup

URL url = new URL("http://www.myurl.com");
Document doc = Jsoup.parse(url, 3000);

Element tables = doc.select("table[class=id]");

for(Element table : tables)
{
     System.out.println(table.toString());
}

EDIT: also tried using Jsoup.connect() instead of parse()

Document doc = null;
try
{
    doc = Jsoup.connect("http://www.myurl.com").get();
} 
catch (IOException e) 
{
    e.printStackTrace();
}

it doesnt work and i have tried doc.select("table tr.id") and "table tr[class=id]") — Clumbsyx
– Clumbsyx, Commented Feb 24, 2015 at 13:25
Works fine here... error is probably in the first two lines... does println(doc) output anything? — Adrian Leonhard
– Adrian Leonhard, Commented Feb 24, 2015 at 13:35
Does the link show anything when you put it in your browser? — Adrian Leonhard
– Adrian Leonhard, Commented Feb 24, 2015 at 13:40

Galunid · Accepted Answer · 2015-02-24 13:52:30Z

0

Try like this:

URL url = new URL("http://www.myurl.com");
Document doc = Jsoup.parse(url, 3000);
// This should work now
Element tables = doc.select("table tr .id");
// This propably should work too
Element tables2 = doc.select("table tr[class*=id]");

for(Element table : tables)
{
     System.out.println(table.toString());
}

From documentation:

public Elements select(String cssQuery) Find elements that match the Selector CSS query, with this element as the starting context. Matched elements may include this element, or any of its children. This method is generally more powerful to use than the DOM-type getElementBy* methods, because multiple filters can be combined, e.g.: •el.select("a[href]") - finds links (a tags with href attributes) •el.select("a[href*=example.com]") - finds links pointing to example.com (loosely)

See the query syntax documentation in Selector.

Parameters: cssQuery - a Selector CSS-like query Returns: elements that match the query (empty if none match)

edited Feb 24, 2015 at 13:52

answered Feb 24, 2015 at 13:40

Galunid

5786 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Clumbsyx Over a year ago

Thank you it works. how do i get the text in between <td class="name">John</td>

Galunid Over a year ago

doc.select("table tr .id td").text(); I thing.

Galunid Over a year ago

stackoverflow.com/questions/5396098/… Try to find answer there

Collectives™ on Stack Overflow

JSoup how to parse table 3 rows

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related