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 [email protected] http://www.xmlsh.org > -----Original Message----- > From: Betty Harvey [mailto:[email protected]] > 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 > > [email protected] > > http://www.xmlsh.org > > > > > >> -----Original Message----- > >> From: [email protected] [mailto:[email protected]] 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. | > >> [email protected] | Washington,DC XML Users Grp > >> URL: http://www.eccnet.com | http://www.eccnet.com/xmlug > >> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ > >> Member of XML Guild (www.xmlguild.org) > >> _______________________________________________ > >> [email protected] > >> http://x-query.com/mailman/listinfo/talk > > > > > > > > _______________________________________________ > > [email protected] > > http://x-query.com/mailman/listinfo/talk > > > > > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ > Betty Harvey | Phone: 410-787-9200 FAX: 9830 > Electronic Commerce Connection, Inc. | > [email protected] | Washington,DC XML Users Grp > URL: http://www.eccnet.com | http://www.eccnet.com/xmlug > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ > Member of XML Guild (www.xmlguild.org) _______________________________________________ [email protected] http://x-query.com/mailman/listinfo/talk
