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: Kendall Shaw <kshaw@xxxxxxxxxxxxxxx>
Date: Tue, 02 Mar 2010 13:04:39 -0800
"KARR, DAVID (ATTSI)" <dk068x@xxxxxxx> writes:

>> -----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
>>    &#13;&#10;
>> for carriage return/line break suffices to make Excel happy.
>
> Thanks, but that doesn't appear to help.  It results in two consecutive
> "question mark in block" characters".  No response on the Excel
> newsgroup so far.

Maybe you are asking how to avoid producing newlines in the output? If
that is the case, it would depend on your XSLT, the data you are
processing and possibly your xslt processor.

Kendall

Current Thread