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

> -----Original Message-----
> From: Martin Honnen [mailto:Martin(_dot_)Honnen(_at_)gmx(_dot_)de]
> Sent: Tuesday, March 02, 2010 10:53 AM
> To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
> 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.

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--