GETKEYS
This function returns a list of all keys from an xml variable. it is similar to the GETKEYSA function, which returns the keys as an array.
You can specify the list separator to use.
You can use the asterisk (*)
character at the beginning or end of a string as a wildcard. For example, to
return particular keys or properties. Asterisks within a string do not act as
wildcards. A wildcard search returns only the first matched key or property.
Note: We cannot guarantee the order in which keys or properties are matched.
Syntax
=GETKEYS("XML_properties","separator")
Example
=GETKEYS(ReportVariables.rv_xmlvariable.text,",")Note: In GETKEYS, the
.text attribute is optional. In GETKEYSA, the
.text attribute is required. GETKEYS is a list function. It can be used in server lists, relational lists, and in slices.