My source xml file has elements in this form:
<field name="Address1">Address1Value</field>
<field name="Address2">Address2Value</field>
<field name="Address3">Address3Value</field>
I need to merge these into a single element, thus:
<field name="Address">Address1Value\r\nAddress2Value\r\nAddress3Value</field>
I know how to get the value of the Address1 element (as below), I just can't figure out how to augment it with the other two. How can I do this?
<xsl:template match="field[@name = 'Address1']">
<field>
<xsl:attribute name="name">Address</xsl:attribute>
<xsl:value-of select="concat(., 'how-do-I-get-the-values-of-Address2-and-Address-here3?')"/>
</field>
</xsl:template>