Import Craigslist information

Question

I'm trying to import the data from Craigslist into Google Sheets. I'm using importxml and have made some progress but can further refine the function.

A3: https://norfolk.craigslist.org/ctd/d/2011-volkswagen-jetta-only-82k-miles/6910694177.html

=IMPORTXML(A3,"//div[@class='mapAndAttrs']//p[@class='attrgroup'][2]")

This seems to return all information but I want to trim it to search for fuel in the result and show gas/diesel/whatever may be.

Answer 1

=QUERY(TRANSPOSE(IMPORTXML(A3,
 "//div[@class='mapAndAttrs']//p[@class='attrgroup'][2]")), 
 "where Col1 contains 'fuel'")

---

=SUBSTITUTE(QUERY(TRANSPOSE(IMPORTXML(A3,
 "//div[@class='mapAndAttrs']//p[@class='attrgroup'][2]")), 
 "where Col1 contains 'fuel'"), "fuel: ", )