EXTRACTPROPERTIESBYFILTER

With EXTRACTPROPERTIESBYFILTER you specify filters to extract specific properties from XML variables. The properties are extracted as XML so you could, for example, extract properties from one XML variable and write them to a second XML variable. The function has the same purpose as EXTRACTPROPERTIES. The difference is that you do not specify the filter in the function. Instead, you refer to a separate FILTER function.

See FILTER

Syntax

EXTRACTPROPERTIES("String xml definition",Filter)

Example

Assume that gv_property holds the unique name and caption of the 'Car tires all season' element in the Product dimension and that cell C44 holds a FILTER function that filters for the unique name. This function returns the unique name:

=EXTRACTPROPERTIESBYFILTER(globalvariables.gv_property,C44)

Related topics