Values that are not inside XML being imported improperly

user_11462274 0
Viewed 20

I'm trying to import links that are inside a map that I'm specifying in detail in the formula:

=IMPORTXML(
           "http://sports.williamhill.com/bet/pt/betlive/9",
           "//tr[@class='rowLive']//td[@scope='col']//a/@href"
          )

The links I'm looking for are at this location on the page:

enter image description here

The expected result would be this:

enter image description here

But for some reason I can't understand, the result is being this:

enter image description here

I would like help to understand what is going on and how I should map the XML correctly so that these values no longer appear.

google-sheets-formula google-sheets
1 Answers

try:

=UNIQUE(FILTER(IMPORTXML("http://sports.williamhill.com/bet/pt/betlive/9",
 "//tr[@class='rowLive']//td[@scope='col']//a/@href"), 
 ISURL(IMPORTXML("http://sports.williamhill.com/bet/pt/betlive/9",
 "//tr[@class='rowLive']//td[@scope='col']//a/@href"))))

enter image description here

user_56326290
Related