<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 08.00.0681.000">
<TITLE>RE: [xquery-talk] XML to TEXT OUTPUT with xQUERY</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">Hi *,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">I have</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">modifie</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">d</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"></FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">my</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> x</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">Q</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">uery and</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">I</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> am</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">close</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"></FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">to</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"></FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">get</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">what</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> I need but I still have a</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">problem</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">.</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">My e</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">n</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">g</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">ine</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"></FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">only return</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">s</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> the</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">information</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> fr</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">o</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">m</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">t</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">he</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">first</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> metadata</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">.</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri"> Any idea?</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri"> I think it can be a b</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">ug of the engine</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">because</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> I d o not see any issue in my development, in fact if</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">I</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> run it under a different x</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">Q</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">uery engine, it works. Do</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> you have a different alternative to my development</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> to see if it works under my engine</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">Thanks in advance</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">Regards</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">xQuery:</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">for $metadata in //MetaData</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">return</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri">string-join(($metadata/Partition/Attr[@name= 'partitionMetaDataFile']/@value,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#1F497D" FACE="Calibri"> </FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri"> </FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#1F497D" FACE="Calibri">$metadata/Partition/Attr[@name= 'CurrentPackageInPartition']/@value,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT COLOR="#1F497D" FACE="Calibri"> </FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"> <FONT COLOR="#1F497D" FACE="Calibri"> </FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"> <FONT COLOR="#1F497D" FACE="Calibri"> $metadata/Partition/Attr[@name= 'TotalPagesInPartition']/@value, '&#xA;'), ' ')</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT COLOR="#1F497D" FACE="Calibri"> </FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"> </SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="es"><FONT COLOR="#1F497D" FACE="Calibri">Output:</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT COLOR="#1F497D" FACE="Calibri">D:\GBPXI\OUT\Print\Extractos\00229-X-00000005_20101108082610_F1_XIGRUPO_101104.afp.xml 15346 7673</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN></P>
<BR>
<BR>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="es-es"></SPAN></B></P>
<P DIR=LTR><B><SPAN LANG="es-es"><FONT COLOR="#400040" SIZE=2 FACE="Arial">Julio de la Vega Pozo</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="es-es"><BR>
</SPAN><SPAN LANG="es"><I></I></SPAN><SPAN LANG="es"><I></I></SPAN><I><SPAN LANG="es-es"></SPAN></I><I><SPAN LANG="es-es"><FONT COLOR="#400040" SIZE=2 FACE="Arial">Consultor Senior</FONT></SPAN></I><SPAN LANG="es"></SPAN><SPAN LANG="es-es"><BR>
</SPAN><SPAN LANG="es"></SPAN><A HREF="mailto:j.vega@helpprintsolutions.com"><SPAN LANG="es"></SPAN><SPAN LANG="es"><U></U></SPAN><U><SPAN LANG="es-es"></SPAN></U><U><SPAN LANG="es-es"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">j.vega@helpprintsolutions.com</FONT></SPAN></U><SPAN LANG="es"></SPAN></A><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN><SPAN LANG="es-es"><FONT COLOR="#400040" SIZE=1 FACE="Verdana">Avda. General Perón, 32 7º G 28020 Madrid tel:</FONT></SPAN><SPAN LANG="es"> </SPAN><A HREF="http://www.plaxo.com/click_to_call?src=jj_signature&To=%2B34+91+598+0533&Email=h.kuperman@helpprintsolutions.com"><SPAN LANG="es"></SPAN><SPAN LANG="es"><U></U></SPAN><U><SPAN LANG="es-es"></SPAN></U><U><SPAN LANG="es-es"><FONT COLOR="#400040" SIZE=1 FACE="Verdana">+34 91 598 053</FONT><FONT COLOR="#400040" SIZE=1 FACE="Verdana">3</FONT></SPAN></U><SPAN LANG="es"></SPAN></A><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN><SPAN LANG="es-es"><FONT COLOR="#400040" SIZE=1 FACE="Verdana"> fax: +34 91 598 0694 </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><A HREF="http://www.helpprintsolutions.com/"><SPAN LANG="es"></SPAN><SPAN LANG="es"><U></U></SPAN><U><SPAN LANG="es-es"></SPAN></U><U><SPAN LANG="es-es"><FONT COLOR="#FF0000" SIZE=1 FACE="Verdana">www.helpprintsolutions.com</FONT></SPAN></U><SPAN LANG="es"></SPAN></A><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN><SPAN LANG="es-es"><FONT COLOR="#000080" SIZE=1 FACE="Verdana">Este correo electrónico contiene información privada y confidencial. Si usted no es el destinatario del mensaje no está</FONT><FONT COLOR="#000080" SIZE=1 FACE="Verdana"> autorizado a leerlo, copiarlo o difundirlo. Si lo ha recibido por error, por favor contacte con el remitente y destruya su contenido.</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN><SPAN LANG="es-es"> <FONT COLOR="#000080" SIZE=1 FACE="Verdana">Privileged/confidential information may be contained in this e-mail. Any reading, copying o dissemination of this communi</FONT><FONT COLOR="#000080" SIZE=1 FACE="Verdana">cation by persons or entities other than its intended recipient is prohibited. If you received this in error, please contact the sender and delete it.</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma">_____________________________________________<BR>
</FONT></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma">De:</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma"> Julio de la Vega [<A HREF="mailto:j.vega@helpprintsolutions.com">mailto:j.vega@helpprintsolutions.com</A>]<BR>
</FONT></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma">Enviado el:</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma"> viernes, 03 de diciembre de 2010 19:40<BR>
</FONT></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma">Para:</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma"> 'Andrew Welch'; 'Michael Kay'<BR>
</FONT></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma">CC:</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma"> 'talk@x-query.com'<BR>
</FONT></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma">Asunto:</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT SIZE=2 FACE="Tahoma"> RE: [xquery-talk] XML to TEXT OUTPUT with xQUERY</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas">Hi *,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas">I send an example of the input file. For every metadata node I need to generate a line of information in a flat file. I have had different results using the same xquery with different xquery engines.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas">Michale, for example with saxonHE I do not get any output if I use !method=text.</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas">The information that I need to get comes from "value" attributes.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas">Thank you</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas">Regards</FONT></SPAN></P>
<BR>
<BR>
<BR>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas">The output that I need to generate:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="en-us"><FONT FACE="Consolas">D:\GBPXI\OUT\Print\Extractos\00229-X-00000005_20101108082610_F1_XIGRUPO_101104.afp.xml 15346 7673</FONT></SPAN></B></P>
<P DIR=LTR><SPAN LANG="es"><B><FONT FACE="Consolas">D:\GBPXI\OUT\Print\Extractos\00229-Y-00000005_20101108082610_F1_XIGRUPO_101104.afp.xml 25567 3444</FONT></B></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN></P>
<BR>
<BR>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">Example of input file:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas"><root></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"><MetaData></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Partition></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <!-- Partition Level Attributes --></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="PartitionNO" value="1" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalPagesInPartition" value="</FONT></SPAN><SPAN LANG="es"><B></B></SPAN><B><SPAN LANG="en-us"><FONT FACE="Consolas">15346</FONT></SPAN></B><SPAN LANG="es"></SPAN><SPAN LANG="en-us"><FONT FACE="Consolas">" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalRectoPagesInPartition" value="7673" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalVersoPagesInPartition" value="7673" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalBlankPagesInsertedInPartition" value="1487" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalSheetsInPartition" value="7673" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="CurrentPackageInPartition" value="5705" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="partitionMetaDataFile" value="D:\GBPXI\OUT\Print\Extractos\00229-X-00000005_20101108082610_F1_XIGRUPO_101104.afp.xml" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> </Partition></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <!-- Stream Level Attributes --></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalPagesInStream" value="15346" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalSheetsInStream" value="7673" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalBlankPagesInsertedInStream" value="1487" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalPartitionsInStream" value="1" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"></MetaData></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"><MetaData ></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Partition></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <!-- Partition Level Attributes --></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="PartitionNO" value="1" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalPagesInPartition" value="25567" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalRectoPagesInPartition" value="3444" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalVersoPagesInPartition" value="3444" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalBlankPagesInsertedInPartition" value="1487" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalSheetsInPartition" value="7673" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="CurrentPackageInPartition" value="5705" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="partitionMetaDataFile" value="D:\GBPXI\OUT\Print\Extractos\00229-Y-00000005_20101108082610_F1_XIGRUPO_101104.afp.xml" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> </Partition></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <!-- Stream Level Attributes --></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalPagesInStream" value="15346" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalSheetsInStream" value="7673" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalBlankPagesInsertedInStream" value="1487" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"> <Attr name="TotalPartitionsInStream" value="1" /></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Consolas"></MetaData></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas"></root></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es-es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es-es"><FONT FACE="Consolas">Julio de la Vega Pozo</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es-es"><FONT FACE="Consolas">Consultor Senior</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es-es"><FONT FACE="Consolas">j.vega@helpprintsolutions.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es-es"><FONT FACE="Consolas">Avda. General Perón, 32 7º G 28020 Madrid tel: +34 91 598 0533 fax: +34 91 598 0694 </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es-es"><FONT FACE="Consolas">www.helpprintsolutions.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es-es"><FONT FACE="Consolas">Este correo electrónico contiene información privada y confidencial. Si usted no es el destinatario del mensaje no está autorizado a leerlo, copiarlo o difundirlo. Si lo ha recibido por error, por favor contacte con el remitente y destruya su contenido.</FONT></SPAN><SPAN LANG="es"></SPAN><SPAN LANG="es-es"> <FONT FACE="Consolas">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.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"></SPAN><SPAN LANG="es"><FONT FACE="Consolas">-----Mensaje original-----<BR>
De: Andrew Welch [<A HREF="mailto:andrew.j.welch@gmail.com">mailto:andrew.j.welch@gmail.com</A>]<BR>
Enviado el: viernes, 03 de diciembre de 2010 11:47<BR>
Para: Julio de la Vega<BR>
CC: talk@x-query.com<BR>
Asunto: Re: [xquery-talk] XML to TEXT OUTPUT with xQUERY</FONT></SPAN><SPAN LANG="es"></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">It's fine to do this with xquery, but you need to post back a small</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">complete sample input and required output...</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">On 3 December 2010 09:20, Julio de la Vega</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas"><j.vega@helpprintsolutions.com> wrote:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Hi *,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> I need to process and xml file with xQuery and generate a text file with the</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> result of my xquery. In my tests I have several issues:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> - Do I have to do it with string function or is there other option?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> - I need to give an specific format to the output but I cannot</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> control line feeds. Is it possible to insert line feed with any command?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> - Do we have to use xslt instead of xquery? Is there any option to</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> do it with xquery?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Little example ot the actual development:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> for $metadata in doc('Estadisticas')/MetaData</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> return</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> (</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> string($metadata/Partition/Attr[@name= 'CurrentPackageInPartition']/@value),</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> string($metadata/Partition/Attr[@name= 'TotalPagesinDocument']/@value),</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> )</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Thanks in advance</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Regards</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Julio de la Vega Pozo</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Consultor Senior</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> j.vega@helpprintsolutions.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Avda. General Perón, 32 7º G 28020 Madrid tel: +34 91 598 0533 fax: +34 91</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> 598 0694</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> www.helpprintsolutions.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> Este correo electrónico contiene información privada y confidencial. Si</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> usted no es el destinatario del mensaje no está autorizado a leerlo,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> copiarlo o difundirlo. Si lo ha recibido por error, por favor contacte con</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> el remitente y destruya su contenido. Privileged/confidential information</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> may be contained in this e-mail. Any reading, copying o dissemination of</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> this communication by persons or entities other than its intended recipient</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> is prohibited. If you received this in error, please contact the sender and</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> delete it.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> _______________________________________________</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> talk@x-query.com</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">> <A HREF="http://x-query.com/mailman/listinfo/talk">http://x-query.com/mailman/listinfo/talk</A></FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">></FONT></SPAN></P>
<BR>
<BR>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">-- </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas">Andrew Welch</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="es"><FONT FACE="Consolas"><A HREF="http://andrewjwelch.com">http://andrewjwelch.com</A></FONT></SPAN></P>
</BODY>
</HTML>