FILTERXML
Returns specific data from the XML content by using the specified XPath.
WebDesktop OnlyWeb & External Data
What it does
Extracts data from XML using XPath query.
Syntax
FILTERXML(xml, xpath)
Arguments
xml(text) — XML string.xpath(text) — XPath expression.
Examples
Parse XML
Get value of <b> node.
FORMULA
=FILTERXML("<a><b>Hello</b></a>", "//b")RESULT
Hello
SAMPLE DATA
| A | |
|---|---|
| 1 | XML |
| 2 | <a><b>Hello</b></a> |