[xquery-talk] Stop Conversion of Character Entities

[Mike Sokolov]

Did you try outputting "
" ?

On 02/21/2012 02:41 PM, Betty Harvey wrote:
> How can you tell XQuery to output the character entity and not the actual
> character.
>
> I am creating an Excel spreadsheet and am trying to put linefeeds into a
> single cell.  I do this all the time with XSLT conversions.
>
> Using the
 character in the XQuery puts a linefeed into the text.  I
> want to output the
. Excel needs this character entity on import in
> order to create linefeeds.  The binary linefeed in the XML doesn't work
> for Excel.
>
> I have tried:
>
> let $newline := fn:string("$#10;") and xs:string
>
> Tried to trick it!
>
> let $newline := fn:concat("&", "#10;")
>
>
> This is easy to do in XSLT (disable-output-escaping="yes") but have
> searched and haven't been able to find an equivalent mechanism in XQuery.
>
> TIA!
>
> Betty
>
> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
> 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
>