[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Google Docs XPATH query and importxml issue

Posted on 2012-08-12
1
Medium Priority
?
464 Views
Last Modified: 2013-03-29
I am trying to execute the following command in GoogleDocs Spreadsheet:

=importxml("http://www.patentbuddy.com/Patent/5652880","//*[@id=first_claim_p_id]")

Hoping to retrieve the text of the first claim from the URL.

The function returns #N/A.

Question: what is the proper command should be used to retrieve the text of claim1?
0
Comment
Question by:cyber-33
1 Comment
 
LVL 9

Accepted Solution

by:
wasiftoor earned 2000 total points
ID: 38297055
I believe you have the right syntax except for the fact that the id should be in single quotes, something like:

=importxml("http://www.patentbuddy.com/Patent/5652880","//*[@id='first_claim_p_id']")
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question