How to parse HTML table using jsoup?

Question

I am trying to parse HTML using jsoup. This is my first time working with jsoup and I read some tutorial on it as well. Below is my HTML table which I am trying to parse - If you see my below table, it has three `tr` as of now (I have shorten it down to have three table rows just for understanding purpose but in general it will be more). Now I would like to extract `Cluster Name` from my below table and it's corresponding `host name` so for example - I would extract `Titan` as cluster name and all its hostname whose status are down. As you can see below for `Titan` cluster name, I have two hostnames `machineA.abc.com` and `machineB.abc.com` in which `machineA` status is `up` but `machineB` status is `down`. So I will print out `Titan` as cluster name and print out `machineB.abc.com` as the hostname since it is down. Is this possible to do using jsoup? ```

Alert

Cluster Name

IP addr

Host Name

…

Accepted Answer

Yes, it is possible with JSoup. First, you select the table. Then, you select the `` tags for rows. You can start from the second index since the first row contains only the column names. Then loop over the `` tags and get the specific index. In your case, the indexes 7 and 5 are important(index 7: Status, index 5: Host Name). Check the status if it equals to `down` and if it is, then add the Host Name to a list. That's all. ``` ArrayList downServers = new ArrayList<>(); Element table = doc.select("table").get(0); //select the first table. Elements rows = table.select("tr"); for (int i = 1; i < rows.size(); i++) { //first row is the col names so skip it. Element row = rows.get(i); Elements cols = row.select("td"); if (cols.get(7).text().equals("down")) { downServers.add(cols.get(5).text()); } } ``` Update: When you find the word `Titan` you can create another loop and look if the cluster name is empty. Edit: I change the `while` loop to `do while` loop. ``` ArrayList downServers = new ArrayList<>(); Element table = doc.select("table").get(0); //select the first table. Elements rows = table.select("tr"); for (int i = 1; i < rows.size(); i++) { //first row is the col names so skip it. Element row = rows.get(i); Elements cols = row.select("td"); if (cols.get(3).text().equals("Titan")) { if (cols.get(7).text().equals("down")) downServers.add(cols.get(5).text()); do { if(i < rows.size() - 1) i++; row = rows.get(i); cols = row.select("td"); if (cols.get(7).text().equals("down") && cols.get(3).text().equals("")) { downServers.add(cols.get(5).text()); } if(i == rows.size() - 1) break; } while (cols.get(3).text().equals("")); i--; //if there is two Titan names consecutively. } } ``` downServers ArrayList will contain the list of down servers hostnames.

How to parse HTML table using jsoup?

Solution

Problem

Related problems