regeximageweb-scrapingxpathgoogle-sheets-formula
Extracting with Google Sheets importxml the xpath style attribute value
Using Google Sheets importXML, I want to extract an xpath attribute value (the image URL) from:
<div class="lazy" style="display: block; background-image: url("https://www.etebg.net/UserFiles/pictures/E28BA835-34EC-C291-F627-856FE8B6DF90.jpg?cache&block&q=100&w=350&h=350");"></div> ```
From the site:
https://www.etebg.net/ro/search/p1/C%C4%83utare.html?q=%25%25
Trying /html/body/div[2]/div[2]/div/a/div[1]/div/@class it works to get the first value of class
but trying /html/body/div[2]/div[2]/div/a/div[1]/div/@style gets N/A
Solution
try:
=ARRAYFORMULA(REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(
"https://www.etebg.net/ro/search/p1/C%C4%83utare.html?q=%25%25")),
"where Col1 contains 'data-src'"), "(https.*jpg)"))
or directly images:
=ARRAYFORMULA(IMAGE(REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(
"https://www.etebg.net/ro/search/p1/C%C4%83utare.html?q=%25%25")),
"where Col1 contains 'data-src'"), "(https.*jpg)")))
- Multi-selection with regex (sublime text 2)
- Regex to match one of two words
- "The big SQL RegEx": How do I RegEx split an easy SQL query (SELECT ... INTO ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY)?
- A Regex to ensure that a string contains at least two words
- Split string before and after double-braced placeholders
- Splitting paragraph into sentences keeping the punctuations - not a dup
- Split string by newlines
- Replace a series of the same character by its number of occurrences in the series
- How to validate 12-Hour Time with regex (regular Expression)
- How can I match a pattern as long as it's not at the beginning with regex?
- Lat/Long mask positive/negative detection
- Pattern attribute value is not a valid regular expression
- A regular expression to exclude a word/string
- Structural pattern matching using regex
- Basic PCRE expression to match word anywhere in a line + another word always at the end of line
- regex for a default URL validation that also includes the use of wildcards for both subdomain and top level domain
- Split string between digital and non-digital characters
- Split text containing sentences and whitelisted phrases into separate lines and prepend each line with a counter
- Inject a delimiter between sets of N characters in a string
- Get all pipe-delimited words inside of all curly braced expressions in a string
- Using regex matched groups in pandas dataframe replace function
- Split string representing a comparison condition into its three parts
- In Python how can I remove a variable number of occurrences of a RegEx pattern from the end of a string?
- using grep inside make to check if a file contains an export to PATH
- Grabbing a specific url from a webpage with re and requests
- QT - QInputDialog How to Validate?
- How to fill gap between two characters with regex
- Golang Regex extract text between 2 delimiters - including delimiters
- Regular expression loop makes duplicate matches due to similar words. How to avoid?
- HTML5 pattern for validating IP with mask