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")

Leave a Reply

Your email address will not be published. Required fields are marked *