Subject: Re: [xsl] How to prevent "question mark in block" characters converting xml to csv? From: Martin Honnen <Martin.Honnen@xxxxxx> Date: Tue, 02 Mar 2010 19:53:11 +0100 |
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.
Martin Honnen http://msmvps.com/blogs/martin_honnen/
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] How to prevent "question mark, KARR, DAVID (ATTSI) | Thread | RE: [xsl] How to prevent "question , KARR, DAVID (ATTSI) |
[xsl] How to prevent "question mark, KARR, DAVID (ATTSI) | Date | [xsl] [Announce] New XSLStyle docum, G. Ken Holman |
Month |