hide certain column in a table

lscjtw · August 2nd, 2007, 12:36 PM

<DATA>Journal1</DATA><DATA>Journal1</DATA><DATA>3000</DATA><DEBIT>400</DEBIT><CREDIT></CREDIT>
<DATA>Journal1</DATA><DATA>Journal1</DATA><DATA>4000</DATA><DEBIT></DEBIT><CREDIT>400</CREDIT>

<xsl:for-each select="DATA">
<TD><xsl:value-of select="."/></TD>
</xsl:for-each>

i use the code to print all the content of the DATA in a table, but now i want to hide the first content of DATA which is "Journal1"
how can i achieve it ? Journal1 can't be any text, so i can't really use DATA= " " to filter out ,
any suggestion ?

mhkay · August 2nd, 2007, 12:53 PM

You haven't made it clear whether you want to generate an empty table cell for the "hidden" data, or to omit the table cell entirely.

Assuming the former,

<TD>
  <xsl:if test=".!='Journal1' or preceding-sibling::DATA='Journal1'">
    <xsl:value-of select="."/>
  </xsl:if>
</TD>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

lscjtw · August 2nd, 2007, 01:26 PM

i already made the condition to work
<xsl:if test="string(DATA) != string(following-sibling::LINE/*)" >

the above is just filter to stop repeat <HTML> </HTML> tag

<TD>
  <xsl:if test=".!='Journal1' or preceding-sibling::DATA='Journal1'">
    <xsl:value-of select="."/>
  </xsl:if>
</TD>
but right now the problem is to omit the first column of the table.
-----------------------------------------------------------
Label | Description | Entity | Account | Debit | Credit
-----------------------------------------------------------
Journal1 | Journal1 | 3000 | 400
Journal1 | Journal1 | 4000 | 400
-----------------------------------------------------------
right now, i want to omit the first column which is the entire Label column section.