“XSLT to convert a xml document back to xml2” – Forum Thread – Discuss

XSLT to convert a xml document back to xml2

This is an open discussion with 4 replies, filed under XSLT.

Search

You are looking at page 1 of 1

- Urvashi
- 16 Oct 10, 1:13 am
- Comment #1

I am creating this topic again as I am now unable to open the previous one. What would be the XSLT like to convert the following xml

<SearchResultsAddressDataSet xmlns="http://tempuri.org/SearchResultsAddressDataSet.xsd">
<AddressResults><ID>10</ID><Country>Aruba</Country><PostalCode>CA 94555-3658</PostalCode><Deleted>N</Deleted><lAddressLines>test text xyz</lAddressLines></AddressResults>
<AddressResults><ID>10</ID><Country>Aruba</Country><PostalCode>CA 94555-3658</PostalCode><Deleted>N</Deleted><lAddressLines>test temp</lAddressLines></AddressResults>
<AddressResults><ID>10</ID><Country>Aruba</Country><PostalCode>CA 94555-3658</PostalCode><Deleted>N</Deleted><lAddressLines>test3 gtrgtrrthyty</lAddressLines></AddressResults>
<AddressResults><ID>11</ID><Country>UK</Country><PostalCode>CA 9fd5-3658</PostalCode><Deleted>N</Deleted><lAddressLines>test</lAddressLines></AddressResults></SearchResultsAddressDataSet>

to the following xml

<SearchResultsAddressDataSet xmlns="http://tempuri.org/SearchResultsAddressDataSet.xsd">
<AddressResults><ID>10</ID><Country>Aruba</Country><PostalCode>CA 94555-3658</PostalCode><Deleted>N</Deleted><lAddressLines>test text xyz,test temp,test3 gtrgtrrthyty</lAddressLines></AddressResults>
<AddressResults><ID>11</ID><Country>UK</Country><PostalCode>CA 9fd5-3658</PostalCode><Deleted>N</Deleted><lAddressLines>test</lAddressLines></AddressResults></SearchResultsAddressDataSet>

i.e. address lines have been comma separated and in one record only.

Thanks

- designermonkey
- 16 Oct 10, 1:44 am
- Comment #2

Is this a Symphony project? It sounds to me like a .Net project.

- bzerangue
- 16 Oct 10, 1:51 am
- Comment #3

@Urvashi - You’ll want to use the Muenchian Method of Grouping. Use Jeni Tennison’s site, http://jenitennison.com/xslt/grouping/ to learn more about it.

- Urvashi
- 16 Oct 10, 2:16 am
- Comment #4

@bzerangue - Thanks for the link it is quiet useful. @designermonkey - No it is not a Symphony project.

- Urvashi
- 18 Oct 10, 7:49 pm
- Comment #5

I tried the following xslt based on the jenitennison link but it doesn’t seem to be working. Can anybody help?

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="rows" match="AddressResults" use="ID" />
<xsl:template match="SearchResultsAddressDataSet">
  <xsl:apply-templates
    select="AddressResults[generate-id(.) = generate-id(key('rows', ID)[1])]" />
</xsl:template>
<xsl:template match="AddressResults">
  <b><xsl:value-of select="ID" /></b>
 <AddressResults><ID><xsl:value-of select="ID" /></ID>
<Country><xsl:value-of select="Country" />
</Country>
<PostalCode><xsl:value-of select="PostalCode" />
</PostalCode><Deleted><xsl:value-of select="Deleted" />
</Deleted><lAddressLines>
     <xsl:for-each select="key('rows', ID)">
        <xsl:value-of select="lAddressLines" />,

     </xsl:for-each>
</lAddressLines>
</AddressResults>
</xsl:template>
</xsl:stylesheet>

Thanks in advance

Create an account or sign in to comment.

Symphony.