Syntax
XMLVALUES(<XPath>;<string [containing XML elements]>)
...
Returns the values selected by the given XPath expression out of an XML document.
Example
...
| 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] |
...