MERGEPROPERTIES

Combines two or more XML property definitions into one and displays it as a string.

You can use the asterisk (*) character at the beginning or end of a string as a wildcard. For example, to return particular keys or properties. Asterisks within a string do not act as wildcards. A wildcard search returns only the first matched key or property.

Note: We cannot guarantee the order in which keys or properties are matched.

Syntax

=MERGEPROPERTIES(XMLProperty1,XMLProperty2....,XMLPropertyN)

Examples

In these examples, assume that there are XML property definitions in cells B5 and B7 and that there are global variables called Var1 and Var2 which each hold XML property definitions.

=MERGEPROPERTIES(B5,B7)

=MERGEPROPERTIES(globalvariables.Var1.text,globalvariables,Var2.text)

=MERGEPROPERTIES(globalvariables.Va1.text,B7)

Properties are merged into the XML definition. If two or more definitions contain the same property name, the most recently added definition overwrites the earlier definition. For example:

The second property definition:

<Table><Row name="Key1"><Property name="p1" value="v21"/>
<Property name="p22" value="v22" /></Row></Table>

merges into the first property definition:

<Table><Row name="Key1"><Property name="p1" value="v1"/>
<Property name="p2" value="v2" /></Row></Table>

The first and second property definitions each contain Property name=p1. The second property definition overwrites the first which results in this merged definition:

<Table><Row name="k1"><Property name="p1" value="v21"/>
<Property name="p2" value="v2" /><Property name="p22" value="v22" /></Row></Table>