FINDKEYSBYFILTER

With FINDKEYSBYFILTER you specify filters to extract specific keys from XML variables. The keys are extracted as XML. You can, for example, extract keys from one XML variable and write them to a second XML variable. The function has the same purpose as FINDKEYS. Each filter consists of a key, property name and property value. In FINDKEYS, you specify the filter in the function. If you use FINDKEYSBYFILTER, you can specify the filter with a separate function.

Syntax

FINDKEYSBYFILTER("XML_properties",filter,"separator")

Note: The function returns #VALUE! if you do not specify a separator, even if the function is used to return a single key.

Example

Assume that the XML variable gv_setproperty holds [Product] as the key and that cell C46 holds a FILTER function. This function returns the [Product] key.

=FINDKEYSBYFILTER(GlobalVariables.gv_setproperty.Text,C46,":")