FINDKEYSA
Returns keys from an xml variable as an array. It is similar to the FINDKEYS function, which returns the keys as a string, but does not require a separator.
See FINDKEYS.
Syntax
FINDKEYSA("String xml definition","Key","Property
name","value")
#ARRAY is displayed in cells that contain arrays.
Example
=FINDKEYSA(GlobalVariables.gv_setproperty2.Text,"[product]","unique", "[product].[all tires].[car tires all season]")When used with the ARRAYTOSTRING function, for example, this example returns [product].
See ARRAY.
Related topics