What is the proper XPath query to find the value in this XML document?

Question

Suppose I have this XML document...

<root>
  <str name="My node's attribute">My string's value</str>
</root>

I want to get the value of the "str" element based on a known value of the elements "name" attribute so I use the following XPath query...

str[@name='My node's attribute']

But that doesn't work for me at least not in classic ASP and C# because of the single quote which of course conflicts with the single quotes used in XPath syntax. An exception is thrown in both cases.

What is a possible solution here if I have the restriction that I can't change the XML document.

Answer 1

try

str[@name='My node''s attribute']

Answer 2

Use " in the xpath instead:-

C#

 string xpath = "str[@name=\"My node's attribute\"]";

VBScript

 Dim xpath : xpath = "str[@name=""My node's attribute""]"

Answer 3

str[@name='My node's attribute']