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 W3C XPath recommendation does not consider namespace declarations to be attribute nodes and does not provide access to them in that capacity. Instead, in XPath every element in an XML document has a number of namespace nodes that can be retrieved using the XPath namespace navigation axis. Each element in the document has a unique set of namespace nodes for each namespace declaration in scope for that particular element.