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