For example, there is a long sentence in Cell A1, see the following screenshot. And now you need to find the 3rd occurrence or position of Character c from the text string in Cell A1. Of course, you can count the characters one by one, and get the exact position result.
XPath, the XML Path Language, is a query language for selecting nodes from an XML document.
How to Query XML with an XPath Expression. 1  Create a new Visual C# Console Application in Visual Studio. NOTE: This example uses a file named Books.xml. 2  Make sure that the project references the System.Xml namespace.