The XPathList()
function executes the given XPath query on XML text and returns the result as a text array.
Follow this link to learn more about XPath.
Syntax
XPathList(xml, xpath)
Returns
An array of text values that contains the result of an xpath query.
If the result is not a list then returns an unknown value.
Parameters
xml
– Text that contains XMLxpath
– Text that contains an XPath query