GETKEYSA
This function returns a list of all keys from an xml variable as an array. It is similar to the GETKEYS function, which returns the keys as a string.
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
=GETKEYSA("XML_properties")
#ARRAY is displayed in cells that contain arrays.
Example
=GETKEYSA(ReportVariables.rv_xmlvariable.text)Note: In GETKEYSA, the
.text attribute is
required. In GETKEYS, the .text
attribute is optional. GETKEYSA is a list function. It can be used in server lists, relational lists, and in slices.