XML -> CSV using XSLT

[stoggers]

Hi,

I have an XSLT script that converts to CSV (comma separated) so that I can load the data into a database.

The problem I have is that the source XML contains embedded HTML tags encoded as escape sequences and I would like to retain these.

An example would be:

<para-text>Example &gt;P&lt;Example...</para-text>

Which is output as <P>Example...

This may seem fine but I need the escape sequences as the data is moving across code pages and the use of escape sequences is an easy way of ensuring transparency.

Assistance appreciated.

Thanks,

Stoggers.

 

[jel]

Best thing would be to have the html-text in CDATA-sections in your XML:
<para-text><![CDATA[Example &gt;P&lt;Example...]]></para-text>

If that's no option you might try to fool xsl by setting the output method to xml and pretend to make CDATA-sections in your output:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="

http://www.w3.org/1999/XSL/Transform"

>
<xslutput method = "xml" cdata-section-elements ="para-text"/>