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.
The root element of the XML data is modeled by an element node. The XPath root node contains the document's root element as well as other information relating to the document.