Re: not copying duplicate node to the output (remove

Play the video

Subject: Re: not copying duplicate node to the output (remove duplicate node)
From: "Wei Chin" <wei_chin@xxxxxxxxxxx>
Date: Fri, 02 Mar 2007 21:20:52 -0500

Hi Mukul,

Thank you so very much for your kind help! The code you wrote worked perfectly.

There is one issue, however, the file I am running is kinda large, it has 8000 lines before the processing, group A and B combined. So each time when I run the code using small amount of data, it worked just perfectly. Whenever I run this code against the real file, which is 8000 lines, the XMLSpy just freezes. Is there any insight about this?

Thank you again and I really appreciate your kindness helping out, this really means a lot to me!

Best Regards,

Wei Chin

----Original Message Follows---- From: "Mukul Gandhi" <gandhi.mukul@xxxxxxxxx> Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: Re: not copying duplicate node to the output (remove duplicate node) Date: Fri, 2 Mar 2007 21:44:09 +0530

I think you have taken the right approach to use the identity template pattern.

I have tried to understand your requirement, and come up with this solution:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:output method="xml" indent="yes"/>

<xsl:template match="node() | @*">
  <xsl:copy>
    <xsl:apply-templates select="node() | @*" />
  </xsl:copy>
</xsl:template>

<xsl:template match="release[@display_on = 'headlines;'][doc_number =
../release[not(@display_on = 'headlines;')]/doc_number]" />

<xsl:template match="release[@display_on =
'headlines;'][normalize-space(doc_number) = '']">
  <xsl:copy-of select="." />
</xsl:template>

<xsl:template match="@display_on[not(. = 'headlines;')]">
  <xsl:attribute name="display_on">
    <xsl:value-of select="concat(., ';headlines')" />
  </xsl:attribute>
</xsl:template>

</xsl:stylesheet>

I hope this helps.

On 3/2/07, Wei Chin <wei_chin@xxxxxxxxxxx> wrote:

Hi I have this problem:
I need to combine two data groups below:
A. conditions:
1. Each release has a unique Id.
2. The two groups have duplicated <doc_number>s. if one <release> in data
group A has a <doc_number> that is already in data group B, remove that
entire <release> node in data group A.
3. Certain <release> does not even have a <doc_number>, but there is a
<doc_number /> tag to represent an empty value. in this case, we keep the
entire <release> node.
4. insert ";headlines;" into the "display_on" attribute to the <release>.
Current file:
<!-- start of file -->
<releases>
<!-- Data group A -->
<release id="2" name="AB" display_on="headlines;" type="NEWS">
 <doc_number>6</doc_number>
</release>
<release id="4" name="CD" display_on="headlines;" type="NOTICE">
 <doc_number>5</doc_number>
</release>
<release id="6" name="EF" display_on="headlines;" type="ORDER">
 <doc_number>4</doc_number>
</release>
<release id="8" name="GH" display_on="headlines;" type="ORDER">
 <doc_number>3</doc_number>
</release>
<release id="10" name="IJ" display_on="headlines;" type="NOTICE">
 <doc_number>2</doc_number>
</release>
<release id="12" name="KL" display_on="headlines;" type="NOTICE">
 <doc_number />
</release>

<!-- Data group B -->
<release id="14" name="XY" display_on="homepage" type="MEMORANDUM">
 <doc_number>5</doc_number>
</release>
<release id="16" name="MN" display_on="sidepage" type="NOTICE">
 <doc_number>4</doc_number>
</release>
<release id="18" name="OP" display_on="otherpage" type="NOTICE">
 <doc_number>3</doc_number>
</release>
</releases>
<!-- end of file -->
Desired resulting file:
<!-- start of file -->
<releases>
<!-- Data group A -->
<release id="2" name="AB" display_on="headlines;" type="NEWS">
 <doc_number>6</doc_number>
</release>
<release id="10" name="IJ" display_on="headlines;" type="NOTICE">
 <doc_number>2</doc_number>
</release>
<release id="12" name="KL" display_on="headlines;" type="NOTICE">
 <doc_number />
</release>

<release id="14" name="XY" display_on="homepage;headlines" type="MEMORANDUM"> <doc_number>5</doc_number> </release> <release id="16" name="MN" display_on="sidepage;headlines" type="NOTICE"> <doc_number>4</doc_number> </release> <release id="18" name="OP" display_on="otherpage;headlines" type="NOTICE"> <doc_number>3</doc_number> </release> </releases>  Right now I have this code written to generate the result, but it only works partially. 1. It removes the duplicated <doc_number> from each release, but it does not remove the whole release. 2. It does not insert ";headlines;" into the "display_on" attribute to the <release> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="xml" omit-xml-declaration="yes"/> <xsl:template match="doc_number"> <xsl:if test="not(string(.))">

 </xsl:if>
 <xsl:if test="not(. = following::fcc_doc_number)">
  <xsl:copy>
   <xsl:apply-templates select="@*|node()"/>
  </xsl:copy>
 </xsl:if>
</xsl:template>
<xsl:template match="@*|node()">
 <xsl:copy>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>
</xsl:stylesheet>
Please anyone help out? thank you!

--
Regards,
Mukul Gandhi

_________________________________________________________________ Dont miss your chance to WIN 10 hours of private jet travel from Microsoft. Office Live http://clk.atdmt.com/MRT/go/mcrssaub0540002499mrt/direct/01/

Current Thread
not copying duplicate node to the output (remove duplicate node) Wei Chin - 2 Mar 2007 00:54:34 -0000 Mukul Gandhi - 2 Mar 2007 16:44:48 -0000 Wei Chin - 3 Mar 2007 18:10:57 -0000 <= Michael Kay - 4 Mar 2007 02:48:13 -0000

<- Previous	Index	Next ->
Re: not copying duplicate nod, Mukul Gandhi	Thread	RE: not copying duplicate nod, Michael Kay
Re: one more issue on removin, Mukul Gandhi	Date	XSLT/XPath Question (Grouping, Kevin Grover
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Cast Your Vote

We need your help – Vote for DataDirect XML Products!

Best SOA or XML site

Winners and finalists announced at SOA World Conference in November.

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page