XSLT

vince.vaugh · July 5th, 2011, 05:07 PM

I have a file that contains data as:

Reporting for Date:2011-06-28
ID , Name , Type
1 , A , T1
2 , B, T1

I need to copy the date on each row, as a new column (as below)

ID , Name , Type Reporting Date
1 , A , T1, 2011-06-28
2, B, T1, 2011-06-28

How can I do this in XSLT 2.0?

samjudson · July 6th, 2011, 02:16 AM

XSLT does have some text parsing functions - specifically the unparsed-text(), tokenize() functions and the <xsl:analyze-string> instruction. This certainly isn't XSLT's strength, as it is usually used for processing XML input and creating XML output, but I'm sure what you are trying to do is possible.

mhkay · July 6th, 2011, 11:59 AM

First convert your data to XML, which is easily enough done using unparsed-text() and tokenize(). Then invert the rows and columns, which might be as simple as doing:

Code:

<xsl:variable name="table" select="."/>
<xsl:for-each select="1 to count(row[1]/cell)">
  <xsl:variable name="n" select="." as="xs:integer"/>
  <newrow>
     <xsl:copy select="$table/row/cell[$n]/>
  </newrow>
</xsl:for-each>