[xsl] rather tricky numbering problem

Subject: [xsl] rather tricky numbering problem
From: a kusa <akusa8@xxxxxxxxx>
Date: Mon, 21 Jun 2010 12:31:44 -0500

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