AnsweredAssumed Answered

Change output in XML file

Question asked by prolog_1 on Jan 11, 2010
Latest reply on Jan 12, 2010 by 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

 








Outcomes