how to append the values using xsl

JohnKiller · July 26th, 2011, 05:15 PM

I want to read the value from one xml and use xls to output these value as one in another xml.

input xml:
<rootNode>
-<Node>
--<anotherNode>
---<Text>Hi</Text>
---<Text>Hello</Text>
---<Text>Hey</Text>
---...
--</anotherNode>
-</Node>
</rootNode>

output xml:
<Rootnode>
-<node1 tag="Text" detail="HiHelloHey" />
</Rootnode>

Requirements:
1. the Text nodes may or may not in the input xml, so we need to determine it, if there is no Text node, do not show node1 in the output xml.
2. the number of Text nodes is uncertain, so it may 3 or 30 Text nodes in the input xml. We need append all of them into the node1 in the output xml.

How can we achieve this goal using xsl? Thanks.

samjudson · July 26th, 2011, 05:55 PM

Well something like:

Code:

	     <xsl:if test="/rootNode/Node/anotherNode/Text">
         <node1 tag="Text">
            <xsl:attribute name="detail">
              <xsl:variable name="temp"><xsl:value-of select="/rootNode/Node/anotherNode/Text"/></xsl:variable>
              <xsl:value-of select="replace($temp, ' ', '')"/>
            </xsl:attribute>
         </node1>
      </xsl:if>

JohnKiller · July 27th, 2011, 10:45 AM

Thank you for your reply.

But I can not use replace function since I am using version 1.0. So what kind of alternative method?

Thank you again.

samjudson · July 27th, 2011, 10:46 AM

Try translate(%temp, ' ', '') instead - it should work.

JohnKiller · July 27th, 2011, 11:12 AM

I changed to translate($temp, ' ', ''), but it only returns the first Text value.

JohnKiller · July 27th, 2011, 11:16 AM

Oh, sorry, I forget to tell that the In the Text nodes, its values are sentences, like "Hi, Anna, this", " is John. How ", "are you?"

Martin Honnen · July 27th, 2011, 11:40 AM

Quote:

Originally Posted by JohnKiller

I want to read the value from one xml and use xls to output these value as one in another xml.

input xml:
<rootNode>
-<Node>
--<anotherNode>
---<Text>Hi</Text>
---<Text>Hello</Text>
---<Text>Hey</Text>
---...
--</anotherNode>
-</Node>
</rootNode>

output xml:
<Rootnode>
-<node1 tag="Text" detail="HiHelloHey" />
</Rootnode>

Requirements:
1. the Text nodes may or may not in the input xml, so we need to determine it, if there is no Text node, do not show node1 in the output xml.
2. the number of Text nodes is uncertain, so it may 3 or 30 Text nodes in the input xml. We need append all of them into the node1 in the output xml.

How can we achieve this goal using xsl? Thanks.

Simply do

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">
  
  <xsl:template match="rootNode">
    <RootNode>
      <xsl:apply-templates select="Node[anotherNode/Text]"/>
    </RootNode>
  </xsl:template>
  
  <xsl:template match="Node">
    <node1 tag="Text">
      <xsl:attribute name="detail">
        <xsl:apply-templates select="anotherNode/Text"/>
      </xsl:attribute>
    </node1>
  </xsl:template>
  
</xsl:stylesheet>

JohnKiller · July 27th, 2011, 12:05 PM

Hi, Martin,

Thank you for your replying.

Is it possible not to use the template to achieve the goal?

Thanks.

Martin Honnen · July 27th, 2011, 12:07 PM

Quote:

Originally Posted by JohnKiller

Is it possible not to use the template to achieve the goal?

Which template exactly are you referring to?

JohnKiller · July 27th, 2011, 12:16 PM

Currently, it is using
<xsl:template match="response">

I am part of the project, so I do not know what is that mean. I write my code under that template.