KARR, DAVID (ATTSI) wrote:
This is partially an Excel question, but I'm writing a stylesheet to
convert an XML file to a CSV, and I have to do some things to make it a
valid CSV, like quoting the values, escaping quotes, etcetera. One
thing that I don't see how to solve is that if the resulting CSV field
has embedded newlines, when I view the result in Excel, the end of each
embedded line has a "question mark in block" character. How do I have
to massage the transformed xml data to prevent that?
Maybe using
for carriage return/line break suffices to make Excel happy.
If you have the line breaks in the input data then the XML parser has
probably normalized them so you will do a replace (with XSLT 2.0) to
ensure you get the right sequence back for Windows specific output.
--
Martin Honnen
http://msmvps.com/blogs/martin_honnen/
--~------------------------------------------------------------------
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>
--~--