XPath concatenate table row cells

Question

I am trying to extract the concatenated cells from a HTML table for each row using XPath. For example, if I have a table like

<table>
<tr><th>FirstName</th><th>LastName</th><th>Title</th></tr>
<tr><td>First1</td><td>Last1</td><td>Title1</td></tr>
<tr><td>First2</td><td>Last2</td><td>Title2</td></tr>
<tr><td>First3</td><td>Last3</td><td>Title3</td></tr>
</table>

I want to extract this data so that I get the full name of the person in each row

First1 Last1
First2 Last2
First3 Last3

I can get each column separately and then merge them in my code later, but prefer to get this done in a single XPath query. I have tried to use concat, but can't figure out where to use the concat.

Thanks in advance.

I tried concat(//tr/td[1]/text(),' ',//tr/td[2]/text()) and several other combinations. The above one gives me just the first row, but not all rows. None of the other combinations were syntactically correct. — Rasika, Jan 29 '14 at 15:53

score 0 · Answer 1 · answered Jan 29 '14 at 15:58

0

The concatenation you tried only concats the xpath, not the nodes. If you want to select more than one nodes, you should use | between them.

//tr//td[1] | //tr//td[2]

answered Jan 29 '14 at 15:58

Kuzgun

4,649
4
34
48

Tried that, but it returns them in different rows and does not do the concatenation. – Rasika Jan 29 '14 at 16:01
Can you post whole code block? I guess you are using select single node or something. – Kuzgun Jan 29 '14 at 16:05
I am just using an XPath plugin on a test page and the only code I have is the XPath at the moment. I am using the XPath Checker on Firefox. – Rasika Jan 29 '14 at 16:08
Can you try //tr//td[not(position() >2)] ? – Kuzgun Jan 29 '14 at 16:13
Tried both //tr/td[1]|//tr/td[2] and //tr//td[1]|//tr//td[2] both return them in separate rows. – Rasika Jan 29 '14 at 16:13
Still no concatenation. They are returned in separate rows. – Rasika Jan 29 '14 at 16:14

XPath concatenate table row cells

1 Answers1