deepcalc
DocsFILTERXML

FILTERXML

View as markdown/docs/functions/filterxml.md Ask Claude about this pageOpens Claude with this page's address

Selects values from an xml STRING with an xpath.

  • Excel: Differs in detail
  • Google Sheets: No equivalent
  • Returns: Array

Examples

=FILTERXML("<r><t>alpha</t></r>", "//t")
Result alpha

Syntax

FILTERXML(xml, xpath)
xml
text required
xpath
text required

Errors

#VALUE!
=FILTERXML(2, 2)
DECODEURLDecodes URL-encoded text. ENCODEURLEncodes text for use in URLs using percent encoding. IMPORTRANGEImports a range from another deepcalc workbook, addressed as {namespace}/{name}: e.g. worldbank/gdp. Resolution is journaled, never live-silent: refreshing the workbook's Sources materializes the target values as ordinary ops, so every upstream change arrives as a reviewable diff. Each source can track the latest version or be pinned to a specific one (the Sources panel). Before the first refresh the cell shows #NAME?. The inline form ={ns}/{name}!worksheet!A1:B10 is equivalent. QUERYRuns SQL-like query on data range.