title: XPath Query for Google Docs ImportXML
body: <p>I'm trying to pull a series of notes out of salesforce, I really just need the body of those notes and I'd really rather avoid copying those manually.</p>
  
  <p>I've got the URLs of the notes into a Google Docs spreadsheet and I'm trying to use ImportXML function to pull specific information out, however I can't seem to get the xpath query right.</p>
  
  <p>After some attempts of my own and a fair bit of research (I am a complete beginner so I might jut be searching for the wrong things) I came up with an xpath query like so:</p>
  
  <pre><code>//div[@class="pbSubsection"]//td[@class="data2Col"][5]//text
  </code></pre>
  
  <p>This results in a parsing error. </p>
  
  <p>I also found that I can open up the Note in Chrome and in developer tools, find the table and right-click to select Copy XPath, which gives me:</p>
  
  <pre><code>//*[@id="ep"]/div[2]/div[2]/table/tbody/tr[5]/td[2]
  </code></pre>
  
  <p>Even if I append //text onto the end. Obviously this is not as fool-proof as I require; is there something I'm missing here or some tool I can use to figure out the problem with these queries? I tried XMLQuire without much luck.</p>
  
  <p>Then again, if some kind soul wants to take a look at the page code (hastily altered to remove sensitive information) and tell me specifically what I'm missing, I'll settle for that:</p>
  
  <p><a href="https://www.dropbox.com/s/peo5i47du1vtsmu/test.html" rel="nofollow">https://www.dropbox.com/s/peo5i47du1vtsmu/test.html</a></p>
  
  <p>The text I'm trying to pull is:</p>
  
  <blockquote>
    <p>teamviewer 12345 
    Server: Customer Name, ST 
    Username: administrator 
    Password: password1</p>
  </blockquote>
  
  <p>Any ideas? Thanks in advance for your time.</p>