[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
> -----Original Message----- > From: Martin Honnen [mailto:Martin.Honnen@xxxxxx] > Sent: Tuesday, March 02, 2010 10:53 AM > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: Re: How to prevent "question mark in block" characters > converting xml to csv? > > 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. The value is in quotes, so that results in the literal " " in Excel. I'll ask on the Excel newsgroup. I have to figure out how to make this work in CSV before I can get it to work in the stylesheet. Thanks.
|
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
|