insert newline in to xml file

hi,

i have a little problem i was hoping to get some assistance with. i have an xml file that i'm transforming in to another xml file with an xsl file. an example of the xsl file follows:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'
        version="1.0"><xsl:output method="xml" indent="yes"/> <xsl:template match="rs:data">
<xml>
<ROWSET>Table_Name="BO_EQUIP_GROUP"
Data_Source="opsEnvironmental"
Refresh_Set="RTO CERMS DURATION"<xsl:apply-templates/>
</ROWSET>
</xml>
</xsl:template>
<xsl:template match="z:row">

<ROW>
<SITE_NAME> <xsl:value-of select="@c2"/> </SITE_NAME>
<EQUIP_NAME> <xsl:value-of select="@Monitor"/> </EQUIP_NAME>
<EQUIP_GROUP_TYPE>Site</EQUIP_GROUP_TYPE>
<EQUIP_GROUP_NAME> <xsl:value-of select="@c2"/> </EQUIP_GROUP_NAME>
</ROW>
<xsl:text disable-output-escaping = "no">&#0D</xsl:text>


<ROW>
<SITE_NAME> <xsl:value-of select="@c2"/> </SITE_NAME>
<EQUIP_NAME> <xsl:value-of select="@Monitor"/> </EQUIP_NAME>
<EQUIP_GROUP_TYPE>Business Unit</EQUIP_GROUP_TYPE>
<EQUIP_GROUP_NAME> <xsl:value-of select="@c3"/> </EQUIP_GROUP_NAME>
</ROW>
<xsl:text disable-output-escaping = "no">&#0D</xsl:text>

<ROW>
<SITE_NAME> <xsl:value-of select="@c2"/> </SITE_NAME>
<EQUIP_NAME> <xsl:value-of select="@Monitor"/> </EQUIP_NAME>
<EQUIP_GROUP_TYPE>Building/Area</EQUIP_GROUP_TYPE>
<EQUIP_GROUP_NAME> <xsl:value-of select="@c4"/> </EQUIP_GROUP_NAME>
</ROW>
<xsl:text disable-output-escaping = "no">&#0D</xsl:text>

</xsl:template>
</xsl:stylesheet>

basically, i'm running one row from the original xml file through this xsl file to get three rows of data. the problem is that right now all three "rows" are output as one row in the second xml file. i need a way to make each "row" it's own row in the second xml file. so how do i get this file to output a new line after each </ROW> tag? i know this may be a little unclear, so if i need to clear something up let me know. thanks.

benStart Free Trial