Subject: RE: [xsl] How to prevent "question mark in block" characters converting xml to csv? From: "KARR, DAVID (ATTSI)" <dk068x@xxxxxxx> Date: Tue, 2 Mar 2010 11:09:15 -0800 |
> -----Original Message----- > From: Martin Honnen [mailto:Martin.Honnen@xxxxxx] > Sent: Tuesday, March 02, 2010 10:53 AM > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: Re: [xsl] 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.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] How to prevent "question , Martin Honnen | Thread | Re: [xsl] How to prevent "question , Martin Honnen |
[xsl] [Announce] New XSLStyle docum, G. Ken Holman | Date | Re: [xsl] How to prevent "question , Martin Honnen |
Month |