Extracting with Google Sheets importxml the xpath style attribute value-CodePudding

Using Google Sheets importXML, I want to extract an xpath attribute value (the image URL) from:

<div  style="display: block; background-image: url(&quot;https://www.etebg.net/UserFiles/pictures/E28BA835-34EC-C291-F627-856FE8B6DF90.jpg?cache&amp;block&amp;q=100&amp;w=350&amp;h=350&quot;);"></div> ```

From the site:
https://www.etebg.net/ro/search/p1/Căutare.html?q=%%

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

CodePudding user response：

try:

=ARRAYFORMULA(REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(
 "https://www.etebg.net/ro/search/p1/Căutare.html?q=%%")), 
 "where Col1 contains 'data-src'"), "(https.*jpg)"))

or directly images:

=ARRAYFORMULA(IMAGE(REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(
 "https://www.etebg.net/ro/search/p1/Căutare.html?q=%%")), 
 "where Col1 contains 'data-src'"), "(https.*jpg)")))