RE: [xsl] Extra spaces

Subject: RE: [xsl] Extra spaces
From: "Surana, Swati " <swati.surana@xxxxxxxx>
Date: Mon, 16 Nov 2009 18:11:54 +0000
I have found the problem and fixed.
Thanks all.

-----Original Message-----
From: Surana, Swati [ICG-IT]
Sent: 16 November 2009 17:14
To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
Subject: RE: [xsl] Extra spaces


To be more clear:
I was trying to output data in the below format:
FWD.AED.01M.0D                            0.000550          0.000550
0.000550       1311/11/2009 12:17:0001AUTOMATED PROCES

But, when I work around with my XSLT def it comes out to be :

FWD . AED . 01M . 0                    000.000300 000.000500 000.000400
13 11/13/2009 15:13:07 01 AUTOMATED PROCES

There are extra spaces between fields (Ex: FWD . AED . 01M . 0) when I don't
need them.

Also, I need the price fields (000.000300, 000.000500 000.000400 ) of fixed
length (i.e. of length 18).


My XML and XSL are as follows:

"<row>"
                        + "<PiTypC length='4'>"            + @PiTypC
+ "</PiTypC>"
                        + @MetaString
                        + "<TenorDate length='10'>"        +
convert(varchar(10),@TenorDate,112)  + "</TenorDate>"
                        + "<DaysBond length='10'>"         +
convert(varchar(10),@DaysBond)       + "</DaysBond>"
                        + "<DaysActual length='10'>"       +
convert(varchar(10),@DaysActual)     + "</DaysActual>"
                        + "<IMMContractBefore length='2'>" +
@IMMContractBefore                   + "</IMMContractBefore>"
                        + "<IMMContractAfter length='2'>"  + @IMMContractAfter
+ "</IMMContractAfter>"
                        + "<IMMDateBefore length='10'>"    +
convert(varchar(10),@IMMDateBefore,112) + "</IMMDateBefore>"
                        + "<IMMDateAfter length='10'>"    +
convert(varchar(10),@IMMDateAfter,112)  + "</IMMDateAfter>"
                        + "<SpotDate length='10'>"         +
convert(varchar(10),@SpotDate,112)   + "</SpotDate>"
                        + "<Basis length='15'>"            +
rtrim(convert(char,@Basis))          + "</Basis>"
                        + "<CrvTag length='20'>"           + rtrim(@CrvTag)
+ "</CrvTag>"
                        + "<CrvRefCode length='20'>"       +
rtrim(@CurveRefCode)                 + "</CrvRefCode>"
                        + "<Label length='20'>"            + @Label
+ "</Label>"
                        + "<RefCode length='20'>"          + @RefCode
+ "</RefCode>"
                        + "<FiI length='15'>"              +
rtrim(convert(char,@FiI))            + "</FiI>"
                        + "<Cusip length='9'>"             + @Cusip
+ "</Cusip>"
                        + "<ISIN length='20'>"             + @ISIN
+ "</ISIN>"
                        + "<Provider length='20'>"         + @Provider
+ "</Provider>"
                        + "<Feed length='80'>"             + @Feed
+ "</Feed>"
                        + "<Time length='5'>"              + @Time
+ "</Time>"
                        + "<SystemDate length='10'>"       +
convert(varchar(10),@SystemDate,112) + "</SystemDate>"
                        + "<LastActivityDateTime>"         +
rtrim(@LastActvyDString)             + "</LastActivityDateTime>"
                        + "<PriceDate length='10'>"        +
convert(varchar(10),@PrcD,112)       + "</PriceDate>"
                        + "<FullPrc1 length='20'>"         +
ltrim(str(@Prc1,20,10))              + "</FullPrc1>"
                        + "<FullPrc2 length='20'>"         +
ltrim(str(@Prc2,20,10))              + "</FullPrc2>"
                        + "<FullPrice length='20'>"        +
ltrim(str(@Price,20,10))             + "</FullPrice>"
                        + "<Prc1 length='10'>"             +
ltrim(str(@Prc1,16,6))               + "</Prc1>"
                        + "<Prc2 length='10'>"             +
ltrim(str(@Prc2,16,6))               + "</Prc2>"
                        + "<Price length='10'>"            +
ltrim(str(@Price,16,6))              + "</Price>"
                        + "<OverrideFlag>"                 + @OverrideFlag
+ "</OverrideFlag>"
                        + "<PrevPriceDate>"                +
convert(varchar(10),@PrevPrcD,112)   + "</PrevPriceDate>"
                        + "<FullPrevPrc1 length='20'>"     +
ltrim(str(@PrevPrc1,20,10))          + "</FullPrevPrc1>"
                        + "<FullPrevPrc2 length='20'>"     +
ltrim(str(@PrevPrc2,20,10))          + "</FullPrevPrc2>"
                        + "<FullPrevPrice length='20'>"    +
ltrim(str(@PrevPrice,20,10))         + "</FullPrevPrice>"
                        + "<PrevPrc1 length='10'>"         +
ltrim(str(@PrevPrc1,16,6))           + "</PrevPrc1>"
                        + "<PrevPrc2 length='10'>"         +
ltrim(str(@PrevPrc2,16,6))           + "</PrevPrc2>"
                        + "<PrevPrice length='10'>"        +
ltrim(str(@PrevPrice,16,6))          + "</PrevPrice>"
                        + "<PrevOverrideFlag>"             + @PrevOverrideFlag
+ "</PrevOverrideFlag>"
                        + "</row>"



And XSL is

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0"> <xsl:strip-space elements="*"/>

<xsl:variable name="num-fmt">0.000000</xsl:variable>
<xsl:variable name="FXFR">FXFR</xsl:variable> <xsl:variable
name="MMKT">MMKT</xsl:variable> <xsl:variable name="NaN">NaN</xsl:variable>
<xsl:variable name="space">  <xsl:text> </xsl:text> </xsl:variable>
<xsl:variable name="VEB">VEB</xsl:variable> <xsl:variable
name="UYP">UYP</xsl:variable> <xsl:variable name="SPOT">SPOT</xsl:variable>
<xsl:variable name="DAILY_SPOTS">Daily SPOTS</xsl:variable>
<xsl:variable name="AppName">CITITRACK                       </xsl:variable>
<xsl:variable name="spaceDataRec">       </xsl:variable>
<xsl:variable name="SysID">USCRS</xsl:variable> <xsl:variable
name="SysSeqNo">01</xsl:variable> <xsl:variable
name="CheckSum">00000000000000000000000</xsl:variable>
<xsl:variable name="footerName">MARKET TRAILER      </xsl:variable>
<xsl:variable name="FWD">FWD</xsl:variable> <xsl:variable
name="FXS">FXS</xsl:variable> <xsl:variable name="DEP">DEP</xsl:variable>
<xsl:variable name="Separator">  <xsl:text>.</xsl:text> </xsl:variable>
<xsl:variable name="Zero">
 <xsl:text>0                   </xsl:text>
</xsl:variable>
<xsl:variable name="DZero">
 <xsl:text>D.0                   </xsl:text>
</xsl:variable>
<xsl:variable name="spaceDR">
 <xsl:text>       </xsl:text>
</xsl:variable>
<xsl:variable name="FWDRateType">13</xsl:variable>
<xsl:variable name="FXSRateType">01</xsl:variable>
<xsl:variable name="DEPRateType">18</xsl:variable>
<xsl:variable name="ErrorCode">01</xsl:variable>
<xsl:variable name="Jan">Jan</xsl:variable> <xsl:variable
name="Feb">Feb</xsl:variable> <xsl:variable name="Mar">Mar</xsl:variable>
<xsl:variable name="Apr">Apr</xsl:variable> <xsl:variable
name="May">May</xsl:variable> <xsl:variable name="Jun">Jun</xsl:variable>
<xsl:variable name="Jul">Jul</xsl:variable> <xsl:variable
name="Aug">Aug</xsl:variable> <xsl:variable name="Sep">Sep</xsl:variable>
<xsl:variable name="Oct">Oct</xsl:variable> <xsl:variable
name="Nov">Nov</xsl:variable> <xsl:variable name="Dec">Dec</xsl:variable>

<xsl:template match="/">
 <xsl:apply-templates select="output"/>
</xsl:template>

<xsl:template match="output">
 <output>
  <row>
   <header>
    <AppName><xsl:value-of select="$AppName"/></AppName>
    <xsl:call-template name="Date_Time_Header">
    </xsl:call-template>
    <xsl:text> </xsl:text>
    <xsl:call-template name="Date_Time_Header">
    </xsl:call-template>
    <xsl:text>                                    </xsl:text>
   </header>
  </row>
  <xsl:apply-templates select="row"/>
  <row>
   <footer>
    <footerName><xsl:value-of select="$footerName"/></footerName>
    <xsl:value-of select="$SysID" />
    <xsl:value-of select="$SysSeqNo" />
    <xsl:call-template name="Date_Time_Trailer">
    </xsl:call-template>
    <rowcount>
     <!-- <xsl:number format="000001" value="count(row)+2" /> -->
     <!-- <xsl:value-of
select="count(row[Tenor!=$SPOT])+count(row[contains(CrvTag,$DAILY_SPOTS)])"/>
-->
     <xsl:number format="000001"
value="count(row[Tenor!=$SPOT])+count(row[contains(CrvTag,$DAILY_SPOTS)])"/>
    </rowcount>
    <xsl:value-of select="$CheckSum" />
   </footer>
  </row>
 </output>
</xsl:template>

<xsl:template name="Date_Time_Header">
 <SnapshotDateTime>
  <xsl:value-of select="substring(row[1]/LastActivityDateTime,5,2)" />
  <xsl:text>/</xsl:text>
  <xsl:variable name="m" select="substring(row[1]/LastActivityDateTime,1,3)"
/>
  <xsl:choose>
  <xsl:when test="$m = $Jan">01</xsl:when>
  <xsl:when test="$m = $Feb">02</xsl:when>
  <xsl:when test="$m = $Mar">03</xsl:when>
  <xsl:when test="$m = $Apr">04</xsl:when>
  <xsl:when test="$m = $May">05</xsl:when>
  <xsl:when test="$m = $Jun">06</xsl:when>
  <xsl:when test="$m = $Jul">07</xsl:when>
  <xsl:when test="$m = $Aug">08</xsl:when>
  <xsl:when test="$m = $Sep">09</xsl:when>
  <xsl:when test="$m = $Oct">10</xsl:when>
  <xsl:when test="$m = $Nov">11</xsl:when>
  <xsl:when test="$m = $Dec">12</xsl:when>
  <xsl:otherwise>
  <xsl:value-of select="$m"/>
  </xsl:otherwise>
  </xsl:choose>
  <xsl:text>/</xsl:text>
  <xsl:value-of select="substring(row[1]/LastActivityDateTime,8,4)" />
  <xsl:text> </xsl:text>
  <xsl:value-of select="substring(row[1]/LastActivityDateTime,13,8)" />
</SnapshotDateTime> </xsl:template>

<xsl:template name="Date_Time_Trailer">
 <SnapshotEndDateTime>
  <xsl:value-of select="substring(row[1]/LastActivityDateTime,8,4)" />
  <xsl:variable name="m" select="substring(row[1]/LastActivityDateTime,1,3)"
/>
  <xsl:choose>
  <xsl:when test="$m = $Jan">01</xsl:when>
  <xsl:when test="$m = $Feb">02</xsl:when>
  <xsl:when test="$m = $Mar">03</xsl:when>
  <xsl:when test="$m = $Apr">04</xsl:when>
  <xsl:when test="$m = $May">05</xsl:when>
  <xsl:when test="$m = $Jun">06</xsl:when>
  <xsl:when test="$m = $Jul">07</xsl:when>
  <xsl:when test="$m = $Aug">08</xsl:when>
  <xsl:when test="$m = $Sep">09</xsl:when>
  <xsl:when test="$m = $Oct">10</xsl:when>
  <xsl:when test="$m = $Nov">11</xsl:when>
  <xsl:when test="$m = $Dec">12</xsl:when>
  <xsl:otherwise>
  <xsl:value-of select="$m"/>
  </xsl:otherwise>
  </xsl:choose>
  <xsl:value-of select="substring(row[1]/LastActivityDateTime,5,2)" />
  <xsl:value-of select="substring(row[1]/LastActivityDateTime,13,8)" />
</SnapshotEndDateTime> </xsl:template>

<xsl:template name="Date_Time_DataRecord">  <SnapshotDateTime>
  <xsl:variable name="m" select="substring(LastActivityDateTime,1,3)"  />
  <xsl:choose>
  <xsl:when test="$m = $Jan">01</xsl:when>
  <xsl:when test="$m = $Feb">02</xsl:when>
  <xsl:when test="$m = $Mar">03</xsl:when>
  <xsl:when test="$m = $Apr">04</xsl:when>
  <xsl:when test="$m = $May">05</xsl:when>
  <xsl:when test="$m = $Jun">06</xsl:when>
  <xsl:when test="$m = $Jul">07</xsl:when>
  <xsl:when test="$m = $Aug">08</xsl:when>
  <xsl:when test="$m = $Sep">09</xsl:when>
  <xsl:when test="$m = $Oct">10</xsl:when>
  <xsl:when test="$m = $Nov">11</xsl:when>
  <xsl:when test="$m = $Dec">12</xsl:when>
  <xsl:otherwise>
  <xsl:value-of select="$m"/>
  </xsl:otherwise>
  </xsl:choose>
  <xsl:text>/</xsl:text>
  <xsl:value-of select="substring(LastActivityDateTime,5,2)" />
  <xsl:text>/</xsl:text>
  <xsl:value-of select="substring(LastActivityDateTime,8,4)" />
  <xsl:text> </xsl:text>
  <xsl:value-of select="substring(LastActivityDateTime,13,8)" />
</SnapshotDateTime> </xsl:template>


<xsl:template match="row">
 <!-- Skip any rows with a zero length Price Date i.e. no price record
available -->  <xsl:if test="string-length(PriceDate)!=0">
 <!-- TermCrcy  -->
 <xsl:variable name="TermCrcy">
  <xsl:choose>
   <xsl:when test="TermCrcy=$VEB">VEF</xsl:when>
   <xsl:when test="TermCrcy=$UYP">UYU</xsl:when>
   <xsl:otherwise>
    <xsl:value-of select="TermCrcy"/>
   </xsl:otherwise>
  </xsl:choose>
 </xsl:variable>
 <xsl:variable name="Tenor">
  <xsl:choose>
      <xsl:when test="string-length(Tenor)=2">
        <xsl:text>0</xsl:text>
        <xsl:value-of select="Tenor"/>
      </xsl:when>
      <xsl:otherwise>
        <xsl:value-of select="Tenor"/>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:variable>
 <!-- Ignore spots from Trestel Output curves - they are all in USD output
spot curve.-->  <xsl:if test="contains(CrvTag,$DAILY_SPOTS) or (Tenor and
Tenor!=$SPOT) or not(Tenor)">
  <row>
   <xsl:choose>
   <xsl:when test="Tenor!=$SPOT">
    <xsl:if test="PiTypC=$FXFR">
     <forward><xsl:value-of select="$FWD" /></forward>
     <sep><xsl:value-of select="$Separator" /></sep>
     <TermCrcy><xsl:value-of select="$TermCrcy"/></TermCrcy>
     <sep><xsl:value-of select="$Separator" /></sep>
     <Tenor><xsl:value-of select="$Tenor"/></Tenor>
     <sep><xsl:value-of select="$Separator" /></sep>
     <extra><xsl:value-of select="$Zero"/></extra>
     <Bid pad-left="18"><xsl:value-of
select="format-number(FullPrc1,$num-fmt)"/></Bid>
     <Ask pad-left="18"><xsl:value-of
select="format-number(FullPrc2,$num-fmt)"/></Ask>
     <Mid pad-left="18"><xsl:value-of
select="format-number(FullPrice,$num-fmt)"/></Mid>
     <spaces><xsl:value-of select="$spaceDR"/></spaces>
     <RateType><xsl:value-of select="$FWDRateType"/></RateType>
     <datetime><xsl:call-template
name="Date_Time_DataRecord"></xsl:call-template></datetime>
     <ErrorCode><xsl:value-of select="$ErrorCode"/></ErrorCode>
     <Additional><xsl:text>HAMPER RATESERVER</xsl:text></Additional>
    </xsl:if>
    <xsl:if test="PiTypC=$MMKT">
     <forward><xsl:value-of select="$DEP" /></forward>
     <sep><xsl:value-of select="$Separator" /></sep>
     <Crcy><xsl:value-of select="Crcy"/></Crcy>
     <sep><xsl:value-of select="$Separator" /></sep>
     <Tenor><xsl:value-of select="$Tenor"/></Tenor>
     <extra><xsl:value-of select="$DZero"/></extra>
     <Bid pad-left="18"><xsl:value-of
select="format-number(FullPrc1,$num-fmt)"/></Bid>
     <Ask pad-left="18"><xsl:value-of
select="format-number(FullPrc2,$num-fmt)"/></Ask>
     <Mid pad-left="18"><xsl:value-of
select="format-number(FullPrice,$num-fmt)"/></Mid>
     <spaces><xsl:value-of select="$spaceDR"/></spaces>
     <RateType><xsl:value-of select="$DEPRateType"/></RateType>
     <datetime><xsl:call-template
name="Date_Time_DataRecord"></xsl:call-template></datetime>
     <ErrorCode><xsl:value-of select="$ErrorCode"/></ErrorCode>
     <Additional><xsl:text>HAMPER RATESERVER</xsl:text></Additional>
    </xsl:if>
   </xsl:when>
   <xsl:otherwise>
     <FXspot><xsl:value-of select="$FXS"/></FXspot>
     <sep><xsl:value-of select="$Separator" /></sep>
     <TermCrcy><xsl:value-of select="$TermCrcy"/></TermCrcy>
     <sep><xsl:value-of select="$Separator" /></sep>
     <Tenor><xsl:text>000</xsl:text></Tenor>
     <sep><xsl:value-of select="$Separator" /></sep>
     <extra><xsl:value-of select="$Zero"/></extra>
     <Bid pad-left="18"><xsl:value-of
select="format-number(FullPrc1,$num-fmt)"/></Bid>
     <Ask pad-left="18"><xsl:value-of
select="format-number(FullPrc2,$num-fmt)"/></Ask>
     <Mid pad-left="18"><xsl:value-of
select="format-number(FullPrice,$num-fmt)"/></Mid>
     <spaces><xsl:value-of select="$spaceDR"/></spaces>
     <RateType><xsl:value-of select="$FXSRateType"/></RateType>
     <datetime><xsl:call-template
name="Date_Time_DataRecord"></xsl:call-template></datetime>
     <ErrorCode><xsl:value-of select="$ErrorCode"/></ErrorCode>
     <Additional><xsl:text>HAMPER RATESERVER</xsl:text></Additional>
   </xsl:otherwise>
   </xsl:choose>
  </row>
 </xsl:if>
 </xsl:if>
</xsl:template>

</xsl:stylesheet>

Thanks & Regards,
Swati

-----Original Message-----
From: Michael Kay [mailto:mike@xxxxxxxxxxxx]
Sent: 16 November 2009 00:20
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] Extra spaces


I can't see how the output relates to your stylesheet code. Your stylesheet is
producing XML, but you are showing text with no tags.

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay

> -----Original Message-----
> From: Surana, Swati [mailto:swati.surana@xxxxxxxx]
> Sent: 15 November 2009 20:51
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> Subject: [xsl] Extra spaces
>
>
> Hello,
> I am using XSLT1.0
>
> I have to get the output in the below format.
> FWD.AED.01M.0                             0.000600
> 0.000600          0.000600       1311/12/2009
> 13:13:0001AUTOMATED PROCES
>
> But with my XSL def I get the following:
> FWD . AED . 1W . 0 000.000050 000.000200 000.000125
> 1311/14/2009 13:13:0001AUTOMATED PROCES
>
>
> I am getting extra spaces between the first part i.e. FWD .
> AED . 1W . 0
>
> My xsl looks like:
>
> ......
> <xsl:template match="row">
>                 <!-- Skip any rows with a zero length Price Date i.e.
> no price record available -->
>                 <xsl:if test="string-length(PriceDate)!=0">
>                         <!-- TermCrcy  -->
>                         <xsl:variable name="TermCrcy">
>                                 <xsl:choose>
>                                         <xsl:when
> test="TermCrcy=$VEB">VEF</xsl:when>
>                                         <xsl:when
> test="TermCrcy=$UYP">UYU</xsl:when>
>                                         <xsl:otherwise>
>                                                 <xsl:value-of
> select="TermCrcy"/>
>                                         </xsl:otherwise>
>                                 </xsl:choose>
>                         </xsl:variable>
>
>                         <!-- Ignore spots from Trestel Output curves -
> they are all in USD output spot curve.-->
>                         <xsl:if
> test="contains(CrvTag,$DAILY_SPOTS) or (Tenor and
> Tenor!=$SPOT) or not(Tenor)">
>                                 <row>
>                                 <xsl:if test="Tenor!=$SPOT">
>                                         <xsl:if test="PiTypC=$FXFR">
>
> <forward><xsl:value-of select="$FWD"
> /></forward><sep><xsl:value-of select="$Separator" /></sep>
>                                         <TermCrcy>
>                                                 <xsl:value-of
> select="$TermCrcy"/>
>
> </TermCrcy><sep><xsl:value-of select="$Separator" /></sep>
>                                         <Tenor>
>                                                 <xsl:value-of
> select="Tenor"/>
>
> </Tenor><sep><xsl:value-of select="$Separator"
> /></sep><extra><xsl:value-of select="$Zero"/></extra>
>                                         <Bid>
>                                                 <xsl:value-of
> select="format-number(FullPrc1,$num-fmt)"/>
>                                         </Bid>
>                                         <Ask>
>                                                 <xsl:value-of
> select="format-number(FullPrc2,$num-fmt)"/>
>                                         </Ask>
>                                         <Mid>
>                                                 <xsl:value-of
> select="format-number(FullPrice,$num-fmt)"/>
>                                         </Mid>
>                                         </xsl:if>
>                                 </xsl:if>
>
>                                 <xsl:if test="Tenor=$SPOT">
>                                         <xsl:copy-of select="PiTypC"/>
>                                         <xsl:text>.</xsl:text>
>                                         <TermCrcy>
>                                                 <xsl:value-of
> select="$TermCrcy"/>
>                                         </TermCrcy>
>                                         <Tenor>
>                                                 <xsl:value-of
> select="Tenor"/>
>                                         </Tenor>
>
>                                         </xsl:if>
>                                 </row>
>                         </xsl:if>
>                 </xsl:if>
>         </xsl:template>
> .......
>
> The XML is:
>
> "<row>"
>                         + "<PiTypC length='4'>"            +
> @PiTypC                              + "</PiTypC>"
>                         + @MetaString
>                         + "<TenorDate length='10'>"        +
> convert(varchar(10),@TenorDate,112)  + "</TenorDate>"
>                         + "<DaysBond length='10'>"         +
> convert(varchar(10),@DaysBond)       + "</DaysBond>"
>                         + "<DaysActual length='10'>"       +
> convert(varchar(10),@DaysActual)     + "</DaysActual>"
>                         + "<IMMContractBefore length='2'>" +
> @IMMContractBefore                   + "</IMMContractBefore>"
>                         + "<IMMContractAfter length='2'>"  +
> @IMMContractAfter                    + "</IMMContractAfter>"
>                         + "<IMMDateBefore length='10'>"    +
> convert(varchar(10),@IMMDateBefore,112) + "</IMMDateBefore>"
>                         + "<IMMDateAfter length='10'>"    +
> convert(varchar(10),@IMMDateAfter,112)  + "</IMMDateAfter>"
>                         + "<SpotDate length='10'>"         +
> convert(varchar(10),@SpotDate,112)   + "</SpotDate>"
>                         + "<Basis length='15'>"            +
> rtrim(convert(char,@Basis))          + "</Basis>"
>                         + "<CrvTag length='20'>"           +
> rtrim(@CrvTag)                       + "</CrvTag>"
>                         + "<CrvRefCode length='20'>"       +
> rtrim(@CurveRefCode)                 + "</CrvRefCode>"
>                         + "<Label length='20'>"            +
> @Label                               + "</Label>"
>                         + "<RefCode length='20'>"          +
> @RefCode                             + "</RefCode>"
>                         + "<FiI length='15'>"              +
> rtrim(convert(char,@FiI))            + "</FiI>"
>                         + "<Cusip length='9'>"             +
> @Cusip                               + "</Cusip>"
>                         + "<ISIN length='20'>"             +
> @ISIN                                + "</ISIN>"
>                         + "<Provider length='20'>"         +
> @Provider                            + "</Provider>"
>                         + "<Feed length='80'>"             +
> @Feed                                + "</Feed>"
>                         + "<Time length='5'>"              +
> @Time                                + "</Time>"
>                         + "<SystemDate length='10'>"       +
> convert(varchar(10),@SystemDate,112) + "</SystemDate>"
>                         + "<LastActivityDateTime>"         +
> rtrim(@LastActvyDString)             + "</LastActivityDateTime>"
>                         + "<PriceDate length='10'>"        +
> convert(varchar(10),@PrcD,112)       + "</PriceDate>"
>                         + "<FullPrc1 length='20'>"         +
> ltrim(str(@Prc1,20,10))              + "</FullPrc1>"
>                         + "<FullPrc2 length='20'>"         +
> ltrim(str(@Prc2,20,10))              + "</FullPrc2>"
>                         + "<FullPrice length='20'>"        +
> ltrim(str(@Price,20,10))             + "</FullPrice>"
>                         + "<Prc1 length='10'>"             +
> ltrim(str(@Prc1,16,6))               + "</Prc1>"
>                         + "<Prc2 length='10'>"             +
> ltrim(str(@Prc2,16,6))               + "</Prc2>"
>                         + "<Price length='10'>"            +
> ltrim(str(@Price,16,6))              + "</Price>"
>                         + "<OverrideFlag>"                 +
> @OverrideFlag                        + "</OverrideFlag>"
>                         + "<PrevPriceDate>"                +
> convert(varchar(10),@PrevPrcD,112)   + "</PrevPriceDate>"
>                         + "<FullPrevPrc1 length='20'>"     +
> ltrim(str(@PrevPrc1,20,10))          + "</FullPrevPrc1>"
>                         + "<FullPrevPrc2 length='20'>"     +
> ltrim(str(@PrevPrc2,20,10))          + "</FullPrevPrc2>"
>                         + "<FullPrevPrice length='20'>"    +
> ltrim(str(@PrevPrice,20,10))         + "</FullPrevPrice>"
>                         + "<PrevPrc1 length='10'>"         +
> ltrim(str(@PrevPrc1,16,6))           + "</PrevPrc1>"
>                         + "<PrevPrc2 length='10'>"         +
> ltrim(str(@PrevPrc2,16,6))           + "</PrevPrc2>"
>                         + "<PrevPrice length='10'>"        +
> ltrim(str(@PrevPrice,16,6))          + "</PrevPrice>"
>                         + "<PrevOverrideFlag>"             +
> @PrevOverrideFlag                    + "</PrevOverrideFlag>"
>                         + "</row>"
>
>
> Kindly advise.
>
> Thanks & Regards,
> Swati

Current Thread