CODEWITHSUNDEEP
xmlxpathimportgoogle-sheets
Mr.Man
Mr.Man

Reputation: 37

Searching through a website with Xpath to find a text part

I am trying to extract the word 'Nahrungsmittel' from the following page: enter link description here

=IMPORTXML("https://www.comdirect.de/inf/aktien/detail/uebersicht.html?ID_NOTATION=135287105";"//td[@class='simple-table__cell']")

I am using the function: IMPORTXML from the google sheets. However, I tried varies ways, either its telling me 'content is empty' or I get the whole table. Could someone tell me, how I can get the the word? data classes are the same however there or two different attributes but I only want the word 'Nahrungsmittel' and not the word 'Branche' (see below).

<td class="simple-table__cell">Branche</td>
<td class="simple-table__cell">Nahrungsmittel</td>

Any help is much appreciated.

Upvotes: 1

Views: 75

Answers (2)

player0
player0

Reputation: 1

=INDEX(IMPORTHTML("https://www.comdirect.de/inf/aktien/detail/uebersicht.html?ID_NOTATION=135287105&SEARCH_REDIRECT=true&REFERER=search.general&REDIRECT_TYPE=SYMBOL&SEARCH_VALUE=NLM",
 "TABLE", 5), 3, 2)

Upvotes: 0

player0
player0

Reputation: 1

=INDEX(IMPORTXML("https://www.comdirect.de/inf/aktien/detail/uebersicht.html?ID_NOTATION=135287105&SEARCH_REDIRECT=true&REFERER=search.general&REDIRECT_TYPE=SYMBOL&SEARCH_VALUE=NLM",
 "//tr/td[@class='simple-table__cell']"), 64, 1)

Upvotes: 1

Related Questions