XMLVALUES

Syntax

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

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

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

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

Column with XML	XMLVALUES 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]