xslt 1.0 count, devide and sort (order?)

vestlink · October 20th, 2011, 06:46 AM

Hi.

As a newbie i'm trying to solve a problem where i have to count the number of an entity and devide it by three in order to get the result sorted like this:

From:

1
2
3
4
5
6
7
8
9

To:

1
4
7
2
5
7
3
6
9

How would i be able to do that

Nicolai

samjudson · October 20th, 2011, 07:00 AM

I am assuming you mean sorting by the remainder when dividing by 3, i.e. Modulus (or the "mod" operator in XPath).

If this was your input XML:

Code:

<root>
  <child>1</child>
  <child>2</child>
  <child>3</child>
  <child>4</child>
  <child>5</child>
  <child>6</child>
  <child>7</child>
  <child>8</child>
  <child>9</child>
</root>

Then the following XSLT could be used:

Code:

<xsl:template match="root">
  <root>
  <xsl:for-each select="child">
    <xsl:sort select="(number(.)-1) mod 3"/>
    <xsl:sort select="number(.)"/>
    <xsl:copy-of select="."/>
  </xsl:for-each>
  </root>
</xsl:template>

vestlink · October 20th, 2011, 07:11 AM

Quote:

Originally Posted by samjudson

I am assuming you mean sorting by the remainder when dividing by 3, i.e. Modulus (or the "mod" operator in XPath).

If this was your input XML:

Code:

<root>
  <child>1</child>
  <child>2</child>
  <child>3</child>
  <child>4</child>
  <child>5</child>
  <child>6</child>
  <child>7</child>
  <child>8</child>
  <child>9</child>
</root>

Then the following XSLT could be used:

Code:

<xsl:template match="root">
  <root>
  <xsl:for-each select="child">
    <xsl:sort select="(number(.)-1) mod 3"/>
    <xsl:sort select="number(.)"/>
    <xsl:copy-of select="."/>
  </xsl:for-each>
  </root>
</xsl:template>

Hi Works great :-)

But if all my numbers have a letter as a prefix like 'L' what then.

Do you have to convert the L+number into somtheing else?

Nicolai

mhkay · October 20th, 2011, 07:17 AM

Please don't ask us to solve a problem for you, and then push back by asking for a solution to a different problem. Explain clearly what input (or what class of inputs) your stylesheet has to handle.

For example, in your sample the input numbers are sorted, and they are dense. Is that a general feature of your inputs, or an accident of your example? We need to know.

vestlink · October 20th, 2011, 07:33 AM

Hi.

I'm sorry if have violated a rule of conduct on this forum, which off couse was not my intension.

My data are sorted, but not dense (if that means that all the values are as described in the silutions example) but scatttered in the xml that is sought sorted. And is an general feature of the xml.

As i said, I'm a newbie/beginner a have rudimentary knowledge compared to you solution contributors.

So to elaborate on my problem, as i clumsily tried to explane in the initial post:

The number i try to get sorted in the way explained in the first post are on this format:

L001
L002
etc.

I was wrongly disregarding the prefix letter in my initial question and regret that in hindsight.

Hope that was answers to your questions :-)

Best regard

Nicolai

samjudson · October 20th, 2011, 07:51 AM

To sort by the number part you would probably use the substring() function to get the number from the text, something like changing this "number(.)" to this "number(substring(.,2))".

vestlink · October 20th, 2011, 08:07 AM

I tried with this but can't the a result.

Can you see the problem?

<xsl:template match="lagringsenhet">
<lagringsenhet>
<xsl:for-each select="asta:lagringsenhet/asta:identifikasjon">
<xsl:sort select="number(substring(.,2)-1) mod 3"/>
<xsl:sort select="number(substring(.,2)"/>
<xsl:copy-of select="."/>
</xsl:for-each>
</lagringsenhet>
</xsl:template>

EDIT:

removed the wrong number of paratheses

samjudson · October 20th, 2011, 08:54 AM

Well given the fact we have no idea what your input XML looks like, and no idea what you are trying to output, nor how the above differs from what you are expecting how on earth could we help?

Also, even though you've edited the above I still think you've got the number of parenthesis wrong.

mhkay · October 20th, 2011, 09:56 AM

>I'm sorry if have violated a rule of conduct on this forum

It's not a rule of conduct, it's just a question of trying to provide the information needed to answer the question, so that you can get the best possible answer in the shortest possible time.