XSLT to csv help

JohnBampton · February 16th, 2012, 01:37 PM

Hi All, I hope someone can help me with this. Using XSLT 1.0 I need to return a csv file. These are two basic examples below:

Code:

<feed>
   <item>
      <field1>value</field1>
      <field2>value</field2>
   </item>
   <item>
      <field1>value></field1>
      <field1a>value</field1a>
      <field2>value</field2>
   </item>
</feed>

needs to return

field1,field1a,field2
value,,value
value,value,value

There is a another consideration we need to accommodate, and that's repeating elements

Code:

<feed>
    <item>
        <field1>value</field1>
        <field2>
            <item>
                <field21>value1</field21>
                <field22>value1</field22>
            </item>
            <item>
                <field21>value2</field21>
                <field22>value2</field22>
            </item>
        </field2>
    </item>
</feed>

needs to return

field1, field2.field21,field2.field22
value,value1,value1
value,value2,value2

I have been trying to write the XSLT for a few hours but no luck.
Can anybody help me?

Regards,

John.