Re: [xsl] How to prevent "question mark in block" characters

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: 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
How to prevent "question mark in block" characters converting xml to csv? KARR, DAVID (ATTSI) - 2 Mar 2010 18:42:20 -0000 Martin Honnen - 2 Mar 2010 18:54:22 -0000 <= KARR, DAVID (ATTSI) - 2 Mar 2010 19:09:51 -0000 Martin Honnen - 2 Mar 2010 19:14:49 -0000 KARR, DAVID (ATTSI) - 2 Mar 2010 20:58:24 -0000 Kendall Shaw - 2 Mar 2010 21:05:14 -0000

<- Previous	Index	Next ->
How to prevent "question mark, KARR, DAVID (ATTSI)	Thread	RE: How to prevent "question , KARR, DAVID (ATTSI)
How to prevent "question mark, KARR, DAVID (ATTSI)	Date	[Announce] New XSLStyle docum, G. Ken Holman
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >