FINDKEYSBYFILTERA

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.

See FINDKEYSBYFILTER.

Syntax

FINDKEYSBYFILTERA("String xml definition",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].

See ARRAY.

Related topics