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.
A backwards compatibility mode is provided to ensure that nearly all XPath 1.0 expressions continue to deliver the same result with XPath 2.0; exceptions to this policy are noted in [I Backwards Compatibility with XPath 1.0].