translating XML into CSV file

vxc2222 · December 29th, 2007, 10:06 AM

Hello,

I have an XML file of the following format
<root>
 <C value=1>
 <C value=2>
 â¦
 <C value=N>

 <parent>
 <A name=1>
 
 
 â¦

 

 </A name=1>
 <A name=2>
 
 
 â¦

 

 </A name=2>
 â¦
 <A name=K>
 
 
 â¦

 

 </A name=K>
 </parent >
</root>

to be translated into CSV of the following format:

Val(C1),Val(C2),...,Val(CN),Val(B1 of A 1),Val(B1 of A2),...,Val(B1 of A K)
Val(C1),Val(C2),...,Val(CN),Val(B2 of A 1),Val(B2 of A2),...,Val(B2 of A K)
.................................................. .................
Val(C1),Val(C2),...,Val(CN),Val(BJ of A 1),Val(BJ of A 2),...,Val (BJ of A K)

I am out of ideas, but since I am very new to XSLT my ideas pool is limited on the subject. Any help is greatly appreciated. Thanks.

Martin Honnen · December 29th, 2007, 12:01 PM

So you want one line in the output for each B element and each line has all C/@value values and then the B/@value values of the same position:

Code:

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

  <xsl:output method="text"/>

  <xsl:param name="ls" select="'#13;#10;'"/>

  <xsl:param name="is" select="','"/>

  <xsl:variable name="c-values" select="/root/C/@value"/>

  <xsl:template match="/">
    <xsl:apply-templates select="root/parent/A[1]/B"/>
  </xsl:template>

  <xsl:template match="B">
    <xsl:variable name="pos" select="position()"/>
    <xsl:apply-templates select="$c-values | ./@value | ../../A/B[position() = $pos]/@value"/>
    <xsl:value-of select="$ls"/>
  </xsl:template>

  <xsl:template match="@value">
    <xsl:value-of select="."/>
    <xsl:if test="position() != last()">
      <xsl:value-of select="$is"/>
    </xsl:if>
  </xsl:template>

</xsl:stylesheet>

With the input corrected to look like this:

Code:

<root>
        <C value="1"></C>
        <C value="2"></C>
        â¦
        <C value="N"></C>

        <parent>
                <A name="1">
                        <B value="1"></B>
                        <B value="2"></B>
                        â¦

                        <B value="J"></B>

                </A>
                <A name="2">
                        <B value="1"></B>
                        <B value="2"></B>
                        â¦

                        <B value="J"></B>

                </A>
                â¦
                <A name="K">
                        <B value="1"></B>
                        <B value="2"></B>
                        â¦

                        <B value="J"></B>

                </A>
        </parent>
</root>

the result is the following:

Code:

1,2,N,1,1,1
1,2,N,2,2,2
1,2,N,J,J,J