xsl-list
[Top] [All Lists]

[xsl] Translating the new lines to line breaks with HTML transformation

2011-12-09 09:03:05
Hi,
  I am using XSLT 1.0 and using is not an option at this time.
I have XML data as below and I need to transform to HTML. I want to insert line 
breaks for the DATES field for the new lines while transforming. I tried to use 
translate but it only replaces one character with another character.

I am very new to XSL, any suggestion would be great..

Thanks


<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <SEASON_CODE>HIGH</SEASON_CODE>
  <SEASON_DESC>High Season</SEASON_DESC>
  <DATES>Thu 2005-09-01 - Wed 2005-11-30
Fri 2006-09-01 - Sun 2006-12-03
Tue 2011-11-01 - Sat 2011-12-17</DATES>
 </ROW>
...


Desired HTML would be

<html>
<body>
<table border="1">
<tr bgcolor="cyan">
<th>SEASON_CODE</th>
<th>SEASON_DESC</th>
<th>DATES</th>
</tr>
<tr>
<td>HIGH</td>
<td>High Season</td>
<td>Thu 2005-09-01 - Wed 2005-11-30</br>
Fri 2006-09-01 - Sun 2006-12-03</br>
Tue 2011-11-01 - Sat 2011-12-17</td>
</tr>

Current xsl

<?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="html"/>
<xsl:template match="/">
<html>
  <body>
   <table border="1">
     <tr bgcolor="cyan">
      <xsl:for-each select="/ROWSET/ROW[1]/*">
       <th><xsl:value-of select="name()"/></th>
      </xsl:for-each>
     </tr>
     <xsl:for-each select="/ROWSET/*">
      <tr>
       <xsl:for-each select="./*">
        <td>  <xsl:value-of select=" text()"/> </td> <!-- I NEED TO DO 
SOMETHING HERE -->
       </xsl:for-each>
      </tr>
     </xsl:for-each>
   </table>
   </body>
</html>
  </xsl:template>
</xsl:stylesheet>

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>