XSLT

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

  <xsl:output method="text"/>

  <xsl:variable name="PackageId" select="2"/>

  <xsl:template match="/">
    <xsl:apply-templates mode="SequenceB" select="NewDataSet/Table[CTD_CTD_PKG_ID =$PackageId]"/>
    <xsl:apply-templates mode="SequenceC" select="NewDataSet/Table[CTD_CTD_PKG_ID =$PackageId][position()=1]"/>
  </xsl:template>

  <xsl:template mode="SequenceB" match="NewDataSet/Table">
    <xsl:choose>
      <xsl:when test="substring(./MSG_TYPE_CODE,2,3)= '102'">
        <xsl:if test="./CTD_SEQ_NUM">
          <xsl:value-of select="concat(':21:',./CTD_SEQ_NUM)"/>
        </xsl:if>
        <xsl:if test="./CURRENCY_CODE">
            <xsl:value-of select="concat(':32B:',./CURRENCY_CODE)"/>
        </xsl:if>
        <xsl:if test="./CTD_SETLD_TRAN_AMT">
          <xsl:value-of select="translate(./CTD_SETLD_TRAN_AMT ,'.',',')"/>
        </xsl:if>
      </xsl:when>
      <xsl:when test="substring(./MSG_TYPE_CODE,2,3)= '103'">
        <xsl:if test="./TRAN_TYPE_CODE">
          <xsl:value-of select="concat(':26T:',./TRAN_TYPE_CODE)"/>
        </xsl:if>
        <xsl:if test="./CTD_VALUE_DATE">
          <xsl:value-of select="concat(':32A:',./CTD_VALUE_DATE)"/>
        </xsl:if>
        <xsl:if test="./CURRENCY_CODE">
          <xsl:value-of select="./CURRENCY_CODE"/>
        </xsl:if>
        <xsl:if test="./CTD_SETLD_TRAN_AMT">
          <xsl:value-of select="translate(./CTD_SETLD_TRAN_AMT,'.',',')"/>
        </xsl:if>
      </xsl:when>
    </xsl:choose>
  </xsl:template>

  <xsl:template mode="SequenceC" match="NewDataSet/Table">
    <xsl:if test="./CTD_VALUE_DATE">
      <xsl:value-of select="concat(':32A:',./CTD_VALUE_DATE)"/>
    </xsl:if>
    <xsl:if test="./CURRENCY_CODE">
      <xsl:value-of select="./CURRENCY_CODE"/>
    </xsl:if>
    <xsl:if test="./CTD_SETLD_TRAN_AMT">
      <xsl:value-of select="translate(./CTD_SETLD_TRAN_AMT,'.',',')"/>
    </xsl:if>
  </xsl:template>

</xsl:stylesheet>