|
|
 next
|
  Subject: Creating 6 records per line in xsl
Author: sadi sadi
Date: 22 Mar 2005 01:07 PM
|
Hi,
I am trying to create a datafile through xml and xsl. what I want
to do is that, read the xml and apply the xsl on it and have a data file.
In my xml file I have (for a start) 7 records.
What I want to do is in the data file that gets created I want to
see only 6 records per line.
For my example, my file chould be as follows.
A00000000132090200002101002325end
111=222=333=444=555=666=
777=
Lets say I had 20 records in my file , then my file would look like
this
A00000000132090200002101002325end
111=222=333=444=555=666=
777=888=999=101010=121212=131313=
1414=1515=16116=17717=1818=1919=
2020=
Which means I cannot have more than 6 records in 1 row.
I have uploaded the xml and xsl i created.... 6 records logic is
not working,
can you please help.
I have also pasted the xsl code here.
<?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" encoding="UTF-8" />
<xsl:template match="/">
<xsl:value-of select="concat('A','000000001','3209020000','2101','002325','end')" />
<xsl:for-each select="Gradsheader/Gradsbody/ROW">
<xsl:variable name="rec_cnt" select="Gradsheader/Gradsbody/ROW/@num" />
<xsl:variable name="modulas" select="$rec_cnt mod 6" />
<xsl:if test="$modulas='1'">
<xsl:variable name="ctr" select="format-number(ceiling($rec_cnt div 6) + 1,'000000000')" />
</xsl:if>
<xsl:value-of select="Gradsheader/Gradsbody/Row/transactioncode" />
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
 learn.xml
xml file having 7 records
test6(1).xsl
xsl file code for 6 record/line limit
|
|
|
|
top