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: "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
>    &#13;&#10;
> for carriage return/line break suffices to make Excel happy.

The value is in quotes, so that results in the literal "&#13;&#10;" 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