[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: How to prevent "question mark in block" characters
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?
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/
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|