Line Counter/Integer Variable

RR_X12 · August 11th, 2010, 09:02 AM

Hi,

I am reading in an XML file and writing out a flat text file. The last line of the flat file has to contain the number of records written out.

How do I set up a integer variable and add to it everytime I write a new row out? Or is there a better way to do this?

Thanks.
RR.

Martin Honnen · August 11th, 2010, 09:11 AM

You can count nodes (or items in general with XSLT/XPath 2.0) with XSLT/XPath, the count function allows that and the xsl: number instruction allows that. If you simply map some input nodes to some output lines than using count on those nodes should suffice, if it is more complicated then you might want to create a temporary output result and count nodes in that result.

samjudson · August 11th, 2010, 09:12 AM

You can't modify variables in XSLT - its a functional programming language.

You'll need to count the number of times you output a record some other way, but without knowing something about your input XML and the XSLT you are using this is impossible to help you further on.

RR_X12 · August 11th, 2010, 09:44 AM

I am trying to get this done using XSLT 1.0.

The input is an 834 X12 (EDI) file in XML format. Don't know if that helps much. The output is flat file fixed.

I cannot count the number of nodes as not each node will be written out.

I might be able to switch to 1.2, but I am trying to stay with 1.0 for possible support reasons.

Thanks again.
RR.

RR_X12 · August 11th, 2010, 09:47 AM

Actually, I might be able to count one partictular node. I am only using one loop, so counting how many times that loop exists may help.

Thanks again!
RR

samjudson · August 11th, 2010, 09:53 AM

There is no such thing as XSLT 1.2 - I assume you mean XSLT 2.0.

And no, knowing it is 834 X12 file doesn't help at all unsurprisingly.

You can count nodes based on some form of criteria, the exact same criteria that you are using to determine if a node should be output.

e.g. count(/root/node[value='output'])

Alternatively you will have to create your output in a temporary variable (this is easier in XSLT 2.0) and then count how many nodes are in it before outputting the variable, e.g.

Code:

<xsl:variable name="output">
  <xsl:apply-templates select="nodes"/>
</xsl:variable>

<xsl:variable name="outputCount" select="count($output/nodes)"/>

<xsl:value-of select="$output"/>
<xsl:valur-of select="$outputCount"/>