<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    It's a little bit product-dependent how the output of a query is
    produced.<br>
    <br>
    There are basically two approaches. One is to write a query whose
    output is a single string (your query produces a sequence of
    strings). The other is to serialize the result of the query using
    the text output method - which, for example, would take a sequence
    of strings and output them space-separated.<br>
    <br>
    Either way, generating new line characters shouldn't be a problem.
    Just write them in the query as numeric character references - &amp;
    # x a ;<br>
    <br>
    Michael Kay<br>
    Saxonica<br>
    <br>
    On 03/12/2010 09:20, Julio de la Vega wrote:
    <blockquote
      cite="mid:001801cb92cb$60a36b10$21ea4130$@vega@helpprintsolutions.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 12 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0cm;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:36.0pt;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
span.EstiloCorreo18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EstiloCorreo19
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:571624232;
        mso-list-type:hybrid;
        mso-list-template-ids:757249982 453679994 201981955 201981957 201981953 201981955 201981957 201981953 201981955 201981957;}
@list l0:level1
        {mso-level-start-at:0;
        mso-level-number-format:bullet;
        mso-level-text:-;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:"Calibri","sans-serif";
        mso-fareast-font-family:Calibri;
        mso-bidi-font-family:"Times New Roman";}
@list l0:level2
        {mso-level-tab-stop:72.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level3
        {mso-level-tab-stop:108.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level4
        {mso-level-tab-stop:144.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level5
        {mso-level-tab-stop:180.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level6
        {mso-level-tab-stop:216.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level7
        {mso-level-tab-stop:252.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level8
        {mso-level-tab-stop:288.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level9
        {mso-level-tab-stop:324.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal">Hi *,<o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal"><span lang="EN-US">I need to process and
            xml file with xQuery and generate a text file with the
            result of my xquery. In my tests I have several issues:<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoListParagraph" style="text-indent: -18pt;"><!--[if !supportLists]--><span
            lang="EN-US"><span style="">-<span style="font: 7pt
                &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><!--[endif]--><span
            lang="EN-US">Do I have to do it with string function or is
            there other option?<o:p></o:p></span></p>
        <p class="MsoListParagraph" style="text-indent: -18pt;"><!--[if !supportLists]--><span
            lang="EN-US"><span style="">-<span style="font: 7pt
                &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><!--[endif]--><span
            lang="EN-US">I need to give an specific format to the output
            but I cannot control line feeds. Is it possible to insert&nbsp;
            line feed with any command?<o:p></o:p></span></p>
        <p class="MsoListParagraph" style="text-indent: -18pt;"><!--[if !supportLists]--><span
            lang="EN-US"><span style="">-<span style="font: 7pt
                &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><!--[endif]--><span
            lang="EN-US">Do we have to use xslt instead of xquery? Is
            there any option to do it with xquery?<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Little example ot the
            actual development:<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">for $metadata&nbsp; in
            doc('Estadisticas')/MetaData<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">return<o:p></o:p></span></p>
        <p class="MsoNormal" style="text-indent: 35.4pt;"><span
            lang="EN-US">(<o:p></o:p></span></p>
        <p class="MsoNormal" style="text-indent: 35.4pt;"><span
            lang="EN-US">string($metadata/Partition/Attr[@name=
            'CurrentPackageInPartition']/@value),<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal" style="text-indent: 35.4pt;"><span
            lang="EN-US">string($metadata/Partition/Attr[@name=
            'TotalPagesinDocument']/@value),<o:p></o:p></span></p>
        <p class="MsoNormal" style="text-indent: 35.4pt;"><span
            lang="EN-US">)<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Thanks in advance<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US">Regards<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal" style="margin-bottom: 12pt;"><b><span
              style="font-size: 10pt; font-family:
              &quot;Arial&quot;,&quot;sans-serif&quot;; color: rgb(64,
              0, 64);" lang="DE"><o:p>&nbsp;</o:p></span></b></p>
        <p class="MsoNormal" style="margin-bottom: 12pt;"><b><span
              style="font-size: 10pt; font-family:
              &quot;Arial&quot;,&quot;sans-serif&quot;; color: rgb(64,
              0, 64);" lang="DE">Julio de la Vega Pozo</span></b><span
            style="color: rgb(64, 0, 64);" lang="DE"><br>
          </span><i><span style="font-size: 10pt; font-family:
              &quot;Arial&quot;,&quot;sans-serif&quot;; color: rgb(64,
              0, 64);" lang="DE">Consultor Senior</span></i><span
            style="color: rgb(64, 0, 64);" lang="DE"><br>
          </span><span style="color: rgb(51, 102, 255);" lang="DE"><a
              moz-do-not-send="true"
              href="mailto:j.vega@helpprintsolutions.com"><span
                style="font-size: 10pt; font-family:
                &quot;Arial&quot;,&quot;sans-serif&quot;;">j.vega@helpprintsolutions.com</span></a><o:p></o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 8pt; font-family:
            &quot;Verdana&quot;,&quot;sans-serif&quot;; color: rgb(64,
            0, 64);">Avda. General Per&oacute;n, 32 7&ordm; G&nbsp; 28020 Madrid&nbsp; tel: </span><span
            style="font-size: 8pt; color: rgb(64, 0, 64);"><a
              moz-do-not-send="true"
href="http://www.plaxo.com/click_to_call?src=jj_signature&amp;To=%2B34+91+598+0533&amp;Email=h.kuperman@helpprintsolutions.com"
              target="_blank" title="Click to call. Cheap rates &amp; no
              headset required!"><span style="font-family:
                &quot;Verdana&quot;,&quot;sans-serif&quot;; color:
                rgb(64, 0, 64);">+34 91 598 0533</span></a></span><span
            style="font-size: 8pt; font-family:
            &quot;Verdana&quot;,&quot;sans-serif&quot;; color: rgb(64,
            0, 64);"> fax: +34 91 598 0694 <o:p></o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 8pt; font-family:
            &quot;Times New Roman&quot;,&quot;serif&quot;; color:
            rgb(64, 0, 64);"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 8pt; color: red;"><a
              moz-do-not-send="true"
              href="http://www.helpprintsolutions.com/"><span
                style="font-family:
                &quot;Verdana&quot;,&quot;sans-serif&quot;; color: red;">www.helpprintsolutions.com</span></a><o:p></o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 8pt; color: red;"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 8pt; font-family:
            &quot;Verdana&quot;,&quot;sans-serif&quot;; color: navy;">Este
            correo electr&oacute;nico contiene informaci&oacute;n privada y
            confidencial. Si usted no es el destinatario del mensaje no
            est&aacute; autorizado a leerlo, copiarlo o difundirlo. Si lo ha
            recibido por error, por favor contacte con el remitente y
            destruya su contenido. </span><span style="font-size: 8pt;
            font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;;
            color: navy;" lang="EN-GB">Privileged/confidential
            information may be contained in this e-mail. Any reading,
            copying o dissemination of this communication by persons or
            entities other than its intended recipient is prohibited. If
            you received this in error, please contact the sender and
            delete it.</span><span style="color: rgb(31, 73, 125);"
            lang="EN-US"><o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
      </div>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
<a class="moz-txt-link-abbreviated" href="mailto:talk@x-query.com">talk@x-query.com</a>
<a class="moz-txt-link-freetext" href="http://x-query.com/mailman/listinfo/talk">http://x-query.com/mailman/listinfo/talk</a></pre>
    </blockquote>
    <br>
  </body>
</html>