FINDKEYSBYFILTERA

This function returns keys from an xml variable as an array. It is similar to the FINDKEYSBYFILTER function, which returns the keys as a string, but does not require a separator.

Syntax

FINDKEYSBYFILTERA("XML_properties",filter)

Example

Assume that the XML variable gv_setproperty holds [product] as the key and that Cell C46 contains a FILTER function:

=FINDKEYSBYFILTERA(GlobalVariables.gv_setproperty.Text,C46).

When used with the ARRAYTOSTRING function, for example, this example returns [product].