Hi,

I want to transform my XML file. From somethings like:

<book>
<title>Java security</title>
<code>005.8 MCGR </code>
<author>Gary & Edward</author>
<content>
<chapters>Why Java security is important </chapters>
<chapters>The Java Security Model</chapters>
....
</content>
<published>1997</published>
<status>
<available>No</available>
<reserved>No</reserved>
</status>
....
</book>

to become something like this:
<book>
<title>Java security</title>
<code>005.8 MCGR </code>
<author>Gary & Edward</author>
<content>
<chapter>Why Java security is important </chapter>
<chapter>The Java Security Model</chapter>
....
</content>
<published>1997</published>
....
</book>

In short, I want to change <chapters> to <chapter> and I want to eliminate <status> tag.

I'm new to XSLT. So, this question might be among one of the very first questions.
Any help would be appreciated. Thank you.

PS. I'm using XSLT 1.0

>In short, I want to change <chapters> to <chapter>

<xsl:template match="chapters">
<chapter>
  <xsl:apply-templates/>
</chapter>
</xsl:template>

 and I want to eliminate <status> tag.

<xsl:template match="status"/>

and you want to copy everything else unchanged:

<xsl:template match="*">
<xsl:copy>
  <xsl:copy-of select="@*"/>
  <xsl:apply-templates/>
</xsl:copy>
</xsl:template>


Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

It's really work!
Thank you very much. =)

Hi,

I have a smilar problem where I'd like to transform from Reporting Services XML to eliminate a tag.

The original XML is:

<?xml version="1.0"?>
<Report xmlns="UC203_x0020_Export_x0020_Returning_x0020_Of ficer_x0020_Details_x0020_for_x0020_Advertising" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="UC203_x0020_Export_x0020_Retur ning_x0020_Officer_x0020_Details_x0020_for_x0020_A dvertising http://localhost/reportserver/folder?%2fUC203+Export+Returning+Officer+Details+f or+Advertising&amp;ElectionEventID=dee73101-8b80-4cae-8c15-e6fed571dfa2&amp;ElectorateTypeID=00000001-0001-0001-0001-000000000006&amp;rs%3aFormat=XML&amp;rs%3aShowHide Toggle%3aisnull=True&amp;rc%3aSchema=True" Name="UC203 Export Returning Officer Details for Advertising">
    <ReturningOfficers>
        <ReturningOfficerDetails_Collection>
            <ReturningOfficerDetails>
                <Electorate>Ballajura</Electorate>
                <RO>Tom Jones</RO>
                <Tel>92913336</Tel>
                <Mob> </Mob>
                <Venue>Ballajura Community College</Venue>
                <Address1>Illawarra Crescent South</Address1>
                <Address2> </Address2>
                <Suburb>BALLAJURA</Suburb>
            </ReturningOfficerDetails>
        </ReturningOfficerDetails_Collection>
    </ReturningOfficers>
</Report>

The ReturningOfficerDetails_Collection and Report tags are to be removed so that the output then becomes:

<?xml version="1.0"?>
<ReturningOfficers>
   <ReturningOfficerDetails>
    <Electorate>Ballajura</Electorate>
    <RO>Tom Jones</RO>
    <Tel>92913336</Tel>
    <Mob> </Mob>
    <Venue>Ballajura Community College</Venue>
    <Address1>Illawarra Crescent South</Address1>
    <Address2> </Address2>
    <Suburb>BALLAJURA</Suburb>
   </ReturningOfficerDetails>
</ReturningOfficers>

Thanks

izbor, please raise your problem in a new thread. I can't see any relationship to the original topic of the thread, and the topics are going to become hopelessly entangled if they are on the same thread.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Ha Ha good joke - not!

Of course they are related - the thread is about transforming XML

Will you just answer the question or will we carry a pedantic tit for tat

izbor, if you treat me like that, then you will certainly not get any help from me.

This whole forum is about transforming XML to XML using XSLT. If you had any experience using such forums, let alone answering questions raised on them, you would know how important it is to structure the information clearly.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Don't hold your breath...

--

Joe (Microsoft MVP - XML)

I hate these forums :(

Sorry for yanking your chain. Mine has been yanked a few times this week.

The thread title got me.