<-prev [Thread] next-> <-prev [Date] next->
Month Index | List Home

Re: [xsl] How to prevent "question mark in block" characters converting xml to csv?

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
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
  &#13;&#10;
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/

Current Thread
<- PreviousIndexNext ->
[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