parsinggoogle-sheetsimporthtml-parsing
IMPORTXML: how to scrape NBA logos from a webpage (with Google Sheets)
Webpage: https://www.sportslogos.net/teams/list_by_league/6/National_Basketball_Association/NBA/logos/
Tool: Google Sheets. Function: importxml
Query: I want to retrieve the link of the NBA logos with importxml.
Tries (without any success):
//a[@title='Atlanta Hawks Logos']/@content
//a[contains(@title,'Atlanta')]
How can I do this?
Solution
If you need the logo based on team_name:
=image(importxml(A$1,"//*[@title='"&A2&" Logos']//img/@src"))
If you need all the images in one go:
=importxml("Webpage","//img/@src")
- Trouble with conversion of duration time strings
- Parse URL in shell script
- C++ alternative for parsing input with sscanf
- How to parse freeform street/postal address out of text, and into components
- How to parse JSON starting with a "{"?
- How to parse json format output of : kubectl get pods using jsonpath
- How to correctly parse incoming HTTP requests
- How to parse ObjectId in a pydantic model?
- How to use EBNF to drive the Parser?
- How can I remove 'www.' from original URL through [urllib] parse in python?
- Parsing XML/XHTML in ActionScript
- Parsing time strings like "1h 30min"
- How can I parse (read) and use JSON in Python?
- Parsing biblatex (.bib) file and converting it to needed vec takes huge amount of time
- Parsing a string representation of nested arrays into an Array
- Rust FromStr where the Type to parse into has Generic field and you won't know the type until after you attempt to parse
- Best way to parse string of email addresses
- ANTLR4 - Token recognition error and mismatched input
- Is there a Python parsing library that can parse a TOML-like format that specifies nested fields with [ParentHeader_ChildSection]?
- Convert Month String to Integer in Java
- Converting a hexadecimal string to a decimal integer
- Ugly Triple Indirection: Extensible Buffer Management Struct
- Does anyone have an easy solution to parsing Exp-Golomb codes using C++?
- Python/Json:Expecting property name enclosed in double quotes
- Fast string parsing in C#
- Parsing variable length strings of fixed column widths
- How can I parse text from a *.PG type file?
- How to reformat JSON in Notepad++
- How to do an Integer.parseInt() for a decimal number?
- Read fixed width record from text file