FINDKEYSBYFILTER

With FINDKEYSBYFILTER you specify filters to extract specific keys from XML variables. The keys are extracted as XML so you could, 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.

See FILTER

Syntax

FINDKEYSBYFILTER("String xml definition",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,":")

Related topics