SSDN - Transform multiple node values to one node value

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

T S

Subject: Transform multiple node values to one node value
Author: T S
Date: 16 Dec 2008 11:09 AM

I need to transform the following XML

<root>
<person>
<name>Name-ABC</name>
<complete-address>
<address-line type="Apt#">10</address-line>
<address-line type="street">Wall St</address-line>
<address-line type="city">New York</address-line>
<address-line type="state">NY</address-line>
<address-line type="Zip">10005</address-line>
</complete-address>
</person>
<person>
.
.
</person>
</root>

to

<root>
<person>
<name>Name-ABC</name>
<complete-address>
<address-line type="Apt#">10</address-line>
<address-line type="street">Wall St</address-line>
<complete-address>
<address>City=New York;State=NY;Zip=10005</address>
</person>
</root>

Appreciate any help in providing a solution using XSL

Thanks
TS

James Durning

Subject: Transform multiple node values to one node value
Author: James Durning
Date: 16 Dec 2008 04:33 PM

<xsl:template match="complete-address">
<xsl:copy>
<xsl:copy-of select="address-line[@type='Apt#' or @type='street']"/>
</xsl:copy>
<address>
<xsl:apply-templates select="address-line[not(@type='Apt#' or @type='street')]"/>
</address>
</xsl:template>
<xsl:template match="address-line">
<xsl:value-of select="@type">
<xsl:text>=</xsl:text>
<xsl:value-of select="."/>
<xsl:if test="not(last())">
<xsl:text>;</xsl:text>
</xsl:if>
</xsl:template>

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.