Google Sheets importXml

Question

I'm trying to target a price on a website using an importXML from Google Sheets. The code I'm targeting looks like:

  <span class="new_price" id="final_price">£29.99</span>

Becuase its inside a class 'new_price' my import isnt working:

  =importXml("http://www.hardware-ironmongers.com/details.aspx?code=7751913"; "//span[@id='final_price']")

Any ideas how to target an ID inside a class?

Cheers

Edited your tags so the XML experts can edit what I think is called the 'xpath' in your function. — danielpiestrak

danielpiestrak danielpiestrak · Accepted Answer · 2012-07-16T21:22:57

I'm no expert, but this looks like it may put you on the right path: