EXTRACTPROPERTIES

With EXTRACTPROPERTIES you specify filters to extract specific properties from XML variables. The properties are extracted as XML so you could, for example, use an action to extract properties from one XML variable and write them to a second XML variable. Each filter consists of a key, property name and property value. In EXTRACTPROPERTIES, you specify the filter in the function. If you use EXRACTPROPERTIESBYFILTER, you can specify the filter with a separate function.

See EXRACTPROPERTIESBYFILTER.

You can specify multiple filters and use the asterisk (*) wildcard to minimize the length of the syntax.

Syntax

EXTRACTPROPERTIES("String xml definition", "[key]", "Property name", "Property value")

Example

If gv_property holds the unique name and caption of an element in the Product dimension, this function returns the unique name:

=EXTRACTPROPERTIES(globalvariables.gv_property, "[Product]", "[unique]", "[Product].[all tires].[car tires all season]")

Example

This example extracts both the unique name and the caption from gv_property:

=EXTRACTPROPERTIES(GlobalVariables.gv_property.Text,"[product]","unique","[product].[all tires].[car tires all season]","[product]","caption","car tires all season")

Example

This example also extracts the unique name and the caption from gv_property but uses wildcards:

=EXTRACTPROPERTIES(GlobalVariables.gv_setproperty.Text,"*","unique","*","caption","*")

Related topics