XMLVALUES

Owned by Juliane Wetzel
Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

Syntax

XMLVALUES(<XPath>;<string [containing XML elements]>)

Description

Returns the values selected by the given XPath expression out of an XML document.

Example

Using XPath: /issues/issue/id/text()

XMLVALUES("/issues/issue/id/text()";#Column_with_XML)

Column with XMLXMLVALUES returns
<issues> <issue> <id>1</id> <name>Fix problem 1</name> </issue> <issue> <id>2</id> <name>Fix problem 2</name> </issue> </issues>[1, 2]
<issues> <issue> <id>3</id> <name>Fix problem 3</name> </issue> <issue> <id>4</id> <name>Fix problem 4</name> </issue> <issue> <id>5</id> <name>Fix problem 5</name> </issue> </issues>[3, 4, 5]
<issues> <issue> <id>6</id> <name>Fix problem 6</name> </issue> <issue> <id>7</id> <name>Fix problem 7</name> </issue> </issues>[6, 7]