FINDKEYSA

This function 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.

Syntax

FINDKEYSA("XML_properties","key","property","value" {,"key","property","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]

.