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
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--