[xquery-talk] Stop Conversion of Character Entities

David Lee dlee at calldei.com
Tue Feb 21 12:24:50 PST 2012


OK Back to the beginning  

First off I didnt know Excel understood XML character entities ...but trusting you 
what does this give you 


<cell><data>hello&#10;big&#10;world</data></cell>

Alternatively have you thought of converting to CSV instead and let Excel read that ?

----------------------------------------
David A. Lee
dlee at calldei.com
http://www.xmlsh.org


> -----Original Message-----
> From: Betty Harvey [mailto:harvey at eccnet.com]
> Sent: Tuesday, February 21, 2012 3:44 PM
> To: David Lee
> Cc: Andrew Welch; xquery-discuss; Mike Sokolov
> Subject: Re: [xquery-talk] Stop Conversion of Character Entities
> 
> This is what I getting (simplified) in the output -- the linefeeds are
> being created:
> 
> <cell><data>hello
> big
> world</data></cell>
> 
> 
> What I want is:
> 
> <cell><data>hello
big
world</data></cell>
> 
> When the Excel 2003 file is opened in Excel the cell is coming out:
> 
> hello big world
> 
> What I want it displayed in list form:
> 
> hello
> big
> world
> 
> Excel doesn't recognize actual linefeeds as linefeeds in a cell -- it
> requires the actual character entity
> 
> Betty
> 
> 
> > I guess Im confused as to what your problem is.
> > Here is ML code I just ran
> >
> > <p>hello world
</p>
> >
> >
> > Result:
> >
> > <p>hello world
> > </p>
> >
> >
> > So my next question is ... how are you printing the result of a MarkLogic
> > XQuery output ?  It seems likely the problem is in your serialization code
> > not ML itself
> >
> >
> >
> > ----------------------------------------
> > David A. Lee
> > dlee at calldei.com
> > http://www.xmlsh.org
> >
> >
> >> -----Original Message-----
> >> From: talk-bounces at x-query.com [mailto:talk-bounces at x-query.com] On
> >> Behalf Of Betty Harvey
> >> Sent: Tuesday, February 21, 2012 3:24 PM
> >> To: Andrew Welch
> >> Cc: xquery-discuss; Mike Sokolov
> >> Subject: Re: [xquery-talk] Stop Conversion of Character Entities
> >>
> >> I guess I should have said MarkLogic is the XQuery engine.  I thought
> >> there might be generic solution.
> >>
> >> Betty
> >>
> >> >> I have tried just about every trick I can think of with no success.
> >> >
> >> >
> >> > declare namespace saxon="http://saxon.sf.net/";
> >> > declare option saxon:output "method=text";
> >> >
> >> > 'a &#10; b'
> >> >
> >> > returns
> >> >
> >> > a 
 b
> >> >
> >> > --
> >> > Andrew Welch
> >> > http://andrewjwelch.com
> >> >
> >>
> >>
> >> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
> >> Betty Harvey                         | Phone:  410-787-9200  FAX: 9830
> >> Electronic Commerce Connection, Inc. |
> >> harvey at eccnet.com                    | Washington,DC XML Users Grp
> >> URL:  http://www.eccnet.com          | http://www.eccnet.com/xmlug
> >> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/
> >> Member of XML Guild (www.xmlguild.org)
> >> _______________________________________________
> >> talk at x-query.com
> >> http://x-query.com/mailman/listinfo/talk
> >
> >
> >
> > _______________________________________________
> > talk at x-query.com
> > http://x-query.com/mailman/listinfo/talk
> >
> 
> 
> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
> Betty Harvey                         | Phone:  410-787-9200  FAX: 9830
> Electronic Commerce Connection, Inc. |
> harvey at eccnet.com                    | Washington,DC XML Users Grp
> URL:  http://www.eccnet.com          | http://www.eccnet.com/xmlug
> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/
> Member of XML Guild (www.xmlguild.org)





More information about the talk mailing list