title: problem for-each / xsl:value-of select="." fmpxmlresult
body: <p>I export to XML one table with one related fields, this file contains cprod, xprod,etc., and when export the table, appears only &quot;cprod&quot; ( i include in export box ...cprod COL(49 )in to xslt,xprod COL(5O)... ETC...  I don't know how I have to make it appear.</p>
  <p>My xslt:</p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
  &lt;xsl:stylesheet version='1.0'
  xmlns:xsl='http://www.w3.org/1999/XSL/Transform'
  xmlns:fm=&quot;http://www.filemaker.com/fmpxmlresult&quot;
  exclude-result-prefixes=&quot;fm&quot;&gt;
    &lt;xsl:output version='1.0' encoding='UTF-8' indent='yes' method='xml' /&gt;
    &lt;xsl:template match=&quot;/&quot;&gt;
    &lt;NFe xmlns=&quot;http://www.portalfiscal.inf.br/nfe&quot;&gt;
  &lt;infNFe&gt;
          &lt;xsl:for-each select=&quot;fm:FMPXMLRESULT/fm:RESULTSET/fm:ROW&quot;&gt;
          
              &lt;xsl:attribute name=&quot;Id&quot;&gt;&lt;xsl:value-of select=&quot;./fm:COL[2]/fm:DATA&quot; /&gt;&lt;/xsl:attribute&gt;
              &lt;xsl:attribute name=&quot;versao&quot;&gt;&lt;xsl:value-of select=&quot;./fm:COL[1]/fm:DATA&quot; /&gt;&lt;/xsl:attribute&gt;
               
               &lt;ide&gt;
                      &lt;cUF&gt;&lt;xsl:value-of select=&quot;./fm:COL[3]/fm:DATA&quot;/&gt;&lt;/cUF&gt;
                      &lt;cNF&gt;&lt;xsl:value-of select=&quot;./fm:COL[4]/fm:DATA&quot;/&gt;&lt;/cNF&gt;
                      &lt;natOp&gt;&lt;xsl:value-of select=&quot;./fm:COL[5]/fm:DATA&quot;/&gt;&lt;/natOp&gt;
                      
                &lt;/ide&gt;
                &lt;emit&gt;
                  &lt;CNPJ&gt;&lt;xsl:value-of select=&quot;./fm:COL[23]/fm:DATA&quot;/&gt;&lt;/CNPJ&gt;
                  &lt;xNome&gt;&lt;xsl:value-of select=&quot;./fm:COL[24]/fm:DATA&quot;/&gt;&lt;/xNome&gt;
                      &lt;enderEmit&gt;
                          &lt;xLgr&gt;&lt;xsl:value-of select=&quot;./fm:COL[25]/fm:DATA&quot;/&gt;&lt;/xLgr&gt;
                          &lt;nro&gt;&lt;xsl:value-of select=&quot;./fm:COL[26]/fm:DATA&quot;/&gt;&lt;/nro&gt;
                          &lt;xBairro&gt;&lt;xsl:value-of select=&quot;./fm:COL[27]/fm:DATA&quot;/&gt;&lt;/xBairro&gt;
                      &lt;/enderEmit&gt;
                       &lt;IE&gt;&lt;xsl:value-of select=&quot;./fm:COL[35]/fm:DATA&quot;/&gt;&lt;/IE&gt;
                       &lt;CRT&gt;&lt;xsl:value-of select=&quot;./fm:COL[36]/fm:DATA&quot;/&gt;&lt;/CRT&gt;
                &lt;/emit&gt;
                &lt;dest&gt;
                  &lt;CNPJ&gt;&lt;xsl:value-of select=&quot;./fm:COL[37]/fm:DATA&quot;/&gt;&lt;/CNPJ&gt;
                  &lt;xNome&gt;&lt;xsl:value-of select=&quot;./fm:COL[38]/fm:DATA&quot;/&gt;&lt;/xNome&gt;
                  &lt;enderDest&gt;
                          &lt;xLgr&gt;&lt;xsl:value-of select=&quot;./fm:COL[39]/fm:DATA&quot;/&gt;&lt;/xLgr&gt;
                          &lt;nro&gt;&lt;xsl:value-of select=&quot;./fm:COL[40]/fm:DATA&quot;/&gt;&lt;/nro&gt;
                          
                   &lt;/enderDest&gt;
                &lt;/dest&gt;
                 
                 &lt;!-- relationed file, and problem--&gt;
                      &lt;xsl:for-each select=&quot;fm:COL[49]/fm:DATA&quot;&gt;
                         &lt;det nItem=&quot;{position()}&quot; &gt;
                              &lt;prod&gt;
                                  &lt;cprod&gt;&lt;xsl:value-of select=&quot;.&quot;/&gt;&lt;/cprod&gt;
                             &lt;!--&lt;CEAN&gt;&lt;xsl:value-of select=?????????????/&gt;&lt;/CEAN&gt;
                                  &lt;xprod&gt;&lt;xsl:value-of select=?????????????/&gt;&lt;/xprod&gt;--&gt;
                              &lt;/prod&gt;
                         &lt;/det&gt;
                      &lt;/xsl:for-each&gt;
          &lt;/xsl:for-each&gt;
   
      &lt;/infNFe&gt;
      &lt;/NFe&gt;
     &lt;/xsl:template&gt;
  &lt;/xsl:stylesheet&gt;
  </code></pre>
  <p>My result:</p>
  <pre><code>&lt;NFe xmlns=&quot;http://www.portalfiscal.inf.br/nfe&quot;&gt;
  &lt;infNFe Id=&quot;NFe35200626697785000197550010000000011248668583&quot; versao=&quot;4.0&quot;&gt;
  &lt;ide&gt;
  &lt;cUF&gt;35&lt;/cUF&gt;
  &lt;cNF&gt;24866858&lt;/cNF&gt;
  &lt;natOp&gt;5902 - 5124 - Retorno / Ind&lt;/natOp&gt;
  &lt;/ide&gt;
  &lt;emit&gt;
  &lt;CNPJ&gt;26697785000197&lt;/CNPJ&gt;
  &lt;xNome&gt;M. D. M. LIMA CONFECCOES ME&lt;/xNome&gt;
  &lt;enderEmit&gt;
  &lt;xLgr&gt;RUA GERALDO COSTA MANSO&lt;/xLgr&gt;
  &lt;nro&gt;96&lt;/nro&gt;
  &lt;xBairro&gt;JARDIM NOSSA SENHORA DO CARMO&lt;/xBairro&gt;
  &lt;/enderEmit&gt;
  &lt;IE&gt;141540863116&lt;/IE&gt;
  &lt;CRT&gt;1&lt;/CRT&gt;
  &lt;/emit&gt;
  &lt;dest&gt;
  &lt;CNPJ&gt;06311274000501&lt;/CNPJ&gt;
  &lt;xNome&gt;TEXTIL MN COMERCIO DE TECIDOS E CONFECCOES LTDA&lt;/xNome&gt;
  &lt;enderDest&gt;
  &lt;xLgr&gt;RUA ALMIRANTE BARROSO&lt;/xLgr&gt;
  &lt;nro&gt;851&lt;/nro&gt;
  &lt;/enderDest&gt;
  &lt;/dest&gt;
  &lt;det nItem=&quot;1&quot;&gt;
  &lt;prod&gt;
     &lt;cprod&gt;000000001000042802&lt;/cprod&gt;
     &lt;cEAN&gt;000000001000042802&lt;/cEAN&gt;
     &lt;xProd&gt;000000001000042802&lt;/NCM&gt;
  &lt;/prod&gt;
  &lt;/det&gt;
  &lt;det nItem=&quot;2&quot;&gt;
  &lt;prod&gt;
      &lt;cprod&gt;7852525654654&lt;/cprod&gt;
      &lt;cEAN&gt;7852525654654&lt;/cEAN&gt;
      &lt;xProd&gt;7852525654654&lt;/NCM&gt;
  &lt;/prod&gt;
  &lt;/det&gt;
  &lt;det nItem=&quot;3&quot;&gt;
  &lt;prod&gt;
      &lt;cprod&gt;456522kfslkdfsjlfj/cprod&gt;
      &lt;cEAN&gt;456522kfslkdfsjlfj&lt;/cEAN&gt;
      &lt;xProd&gt;456522kfslkdfsjlfj&lt;/NCM&gt;
  &lt;/prod&gt;
  &lt;/det&gt;
  &lt;/infNFe&gt;
  </code></pre>
     
  <p>But I need the following result:</p>
  <pre><code>&lt;!-- this first part result is ok --&gt;
  &lt;det nItem=&quot;1&quot;&gt;
   &lt;prod&gt;
     &lt;cProd&gt;000000001000042801&lt;/cProd&gt;
     &lt;cEAN&gt;SEM GTIN&lt;/cEAN&gt;
     &lt;xProd&gt;CALCAS FEMININAS CORTADAS, 68% ALGODAO, 29% POLIESTER E 3% ELASTANO&lt;/xProd&gt;
     
     &lt;/prod&gt;
  &lt;det nItem=&quot;2&quot;&gt;
   &lt;prod&gt;
     &lt;cProd&gt;7852525654654&lt;/cProd&gt;
     &lt;cEAN&gt;SEM GTIN&lt;/cEAN&gt;
     &lt;xProd&gt;CALCA MASCULINA&lt;/xProd&gt;
     
     &lt;/prod&gt;
  &lt;det nItem=&quot;3&quot;&gt;
   &lt;prod&gt;
     &lt;cProd&gt;456522kfslkdfsjlfj&lt;/cProd&gt;
     &lt;cEAN&gt;SEM GTIN&lt;/cEAN&gt;
     &lt;xProd&gt;CALCA&lt;/xProd&gt;
     &lt;/prod&gt;
  &lt;/det&gt;
  </code></pre>
  <p>full not filtered</p>
  <pre><code>&lt;FMPXMLRESULT xmlns=&quot;http://www.filemaker.com/fmpxmlresult&quot;&gt;
  &lt;ERRORCODE&gt;0&lt;/ERRORCODE&gt;
  &lt;PRODUCT BUILD=&quot;07-03-2018&quot; NAME=&quot;FileMaker&quot; VERSION=&quot;ProAdvanced 17.0.2&quot;/&gt;
  &lt;DATABASE DATEFORMAT=&quot;D/m/yyyy&quot; LAYOUT=&quot;&quot; NAME=&quot;GestNfe2020.fmp12&quot; RECORDS=&quot;1&quot; TIMEFORMAT=&quot;k:mm:ss &quot;/&gt;
  &lt;METADATA&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;versao&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;idxml&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cUF&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cNF&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;natOp&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;mod&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Serie&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;nNF&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;dhEmi&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;dhSaiEnt&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;tpNF&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;idDest&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cMunFG&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;tpImp&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;tpEmis&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cDV&quot; TYPE=&quot;NUMBER&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;tpAmb&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;finNFe&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;indFinal&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;indPres&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;procEmi&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;verProc&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::CNPJ&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::xNome&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::xLgr&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::nro&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::xBairro&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::cMun&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cMunFG para Emitiente::municipio&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;UF para Emitiente::UF&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::CEP&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::cPais&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cPais para Emitiente::PAIS&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::fone&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::IE&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Emitiente::CRT&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::CNPJ&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::xNome&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::xLgr&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::nro&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::xBairro&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::cMun&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::xMun&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::UF&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::CEP&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::cPais&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;cPais para Destinatario::PAIS&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;Destinatarios::fone&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;LINEAS::cProd&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;LINEAS::cEAN&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;FIELD EMPTYOK=&quot;YES&quot; MAXREPEAT=&quot;1&quot; NAME=&quot;LINEAS::xProd&quot; TYPE=&quot;TEXT&quot;/&gt;
  &lt;/METADATA&gt;
  &lt;RESULTSET FOUND=&quot;1&quot;&gt;
  &lt;ROW MODID=&quot;6&quot; RECORDID=&quot;219&quot;&gt;
  &lt;COL&gt;
  &lt;DATA&gt;4.0&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;NFe35200626697785000197550010000000011248668583&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;35&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;24866858&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;5902 - 5124 - Retorno / Ind&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;55&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;2020-06-19T03:30:26-03:00&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;2020-06-19T03:30:26-03:00&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;3550308&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;3&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;0&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;9&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;0&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;GestNfev.3.4.0&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;26697785000197&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;M. D. M. LIMA CONFECCOES ME&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;RUA GERALDO COSTA MANSO&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;96&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;JARDIM NOSSA SENHORA DO CARMO&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;3550308 &lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;São Paulo&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;SP&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;08270580&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;0000&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;otro&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;04431414900&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;141540863116&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;06311274000501&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;TEXTIL MN COMERCIO DE TECIDOS E CONFECCOES LTDA&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;RUA ALMIRANTE BARROSO&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;851&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;BRAS&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;3550308&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;SAO PAULO&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;SP&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;03025-001&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;1058&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;BRASIL&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA/&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;000000001000042802&lt;/DATA&gt;
  &lt;DATA&gt;7852525654654&lt;/DATA&gt;
  &lt;DATA&gt;456522kfslkdfsjlfj&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;SEM GTIN&lt;/DATA&gt;
  &lt;DATA/&gt;
  &lt;DATA/&gt;
  &lt;/COL&gt;
  &lt;COL&gt;
  &lt;DATA&gt;CALCAS MASCULINA CORTADAS, 74% ALGODAO, 12% POLIESTER, 12% MODAL E 2%&lt;/DATA&gt;
  &lt;DATA&gt;CALCAS MASCULINA &lt;/DATA&gt;
  &lt;DATA&gt;CALCAS&lt;/DATA&gt;
  &lt;/COL&gt;
  &lt;/ROW&gt;
  &lt;/RESULTSET&gt;
  &lt;/FMPXMLRESULT&gt;
  </code></pre>