[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: rather tricky numbering problem

Subject: Re: rather tricky numbering problem
From: Michael Kay <mike@xxxxxxxxxxxx>
Date: Mon, 21 Jun 2010 19:27:05 +0100
Re:  rather tricky numbering problem
Looks like a fairly simple grouping problem, combined with handling multiple input and output files.

<xsl:for-each-group select="collection('folder')" group-by="/*/product-num/substring(., 1, 5)">
<xsl:when test="count(current-group() gt 1)">
<xsl:for-each select="current-group()">
<xsl:apply-templates select=".">
<xsl:with-param name="new-prod-num" select="concat(current-grouping-key(), position()"/>
<xsl:apply-templates select=".">
<xsl:with-param name="new-prod-num" select="current-grouping-key()"/>

Michael Kay

On 21/06/2010 18:31, a kusa wrote:

I have a requirement which  I am not sure if this can be done in XSLT.
I will try to explain it  theoretically as much as possible and please
let me know if there is any way this can be done in XSLT.

I have a bunch of XML files in a folder.

The XML files have an element called 'prod-num' which is an 8-digit
number the first 5 of which follows a particular numbering scheme
based on what the XML is for.

For example, if the XML represents books for children,  the prod-num
has the following numbering scheme : 1212 - 1.
If the XML data represents books for Science, the prod-num has the
following numbering scheme: 1212-2

Now, here is what needs to happen.

The last three of the prod-num needs to be sequentially numbered if
the first 5 are the same.

So, in my explained example above, the transformation needs to read
the folder with the XML files, and read through the prod-num values.

If there are say two XML files with 1212-1, then the first one needs
to be updated with 1212-1001, the second one becomes 1212-1002.

Can the experts please give me some tips and ideas to resolve this?

Thanks in advance

Current Thread


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

Buy Stylus Studio Now

Download The World's Best XML IDE!

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

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.