PowerUp Description
The pwrPARSEXML PowerUp function parses through XML using an XPATH query to return the XML element sought.
PowerUp Syntax
pwrPARSEXML(value, query)
The pwrPARSEXML PowerUp function has the following arguments:
value – Required. This is the XML on which to apply the basic formatting.
query – Required. This is the XPATH query to use on the XML.
Return Value
pwrPARSEXML will return the result of query.
Remarks
Enter an array formula to return multiple values that meet the query statement.
Example
=pwrPARSEXML(A1, "/root/note/title")