GETKEY
GETKEY returns the first occurrence of a specified key from an xml variable.
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
=GETKEY("String xml definition", "Key")
Example
This example returns the first key beginning with P from the specified variable:
=GETKEYS("String xml definition","P*")