4 Replies Latest reply on Jan 12, 2010 9:21 AM by prolog_1

    Change output in XML file

    prolog_1

      Title

      Change output in XML file

      Post

      Hallo

      Can someone help me with this XSL file

       

      <?xml version="1.0" encoding="UTF-8"?>
      <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
          xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp">
          <xsl:output method="xml" version="1.0" encoding="ISO-8859-1"  omit-xml-declaration="no" indent="yes"/>

       <xsl:strip-space elements="*" />
        <xsl:preserve-space elements="*"/>

        <xsl:template match="/">
            
           <xsl:for-each select="/fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW">
       

                 <!-- START-ENTRIES -->
                          <xsl:comment>START-ENTRIES</xsl:comment>
        
        <A><xsl:value-of select="./fmp:COL[1]/fmp:DATA"/></A>
                          <B><xsl:value-of select="./fmp:COL[2]/fmp:DATA"/></B>
                          <C><xsl:value-of select="./fmp:COL[3]/fmp:DATA"/></C>

       </xsl:for-each>
       
          </xsl:template>
      </xsl:stylesheet>

       

      The Output in XML =

       

       <?xml version="1.0" encoding="ISO-8859-1"?>
      <!--START-ENTRIES-->
      <A>A</A>
      <B/>
      <C>B</C>

      But I want Output like this :

       

      <?xml version="1.0" encoding="ISO-8859-1"?>
      <!--START-ENTRIES-->
      <A>A</A>
      <B></B>
      <C>B</C>

       

      Thanks