RE: Answer- XSLT

14 Sep 2004 12:51:53 -0000

Hi Jerald,

 

            Thanks for help.

 

            I tried with what you have sent but still I am not getting What I required.

 

            Output that what I am getting is :

    

                        JPY

                        ACOM

                        IPV

                        2004-08-17+04:00

                        LDN

                        ICT

                        0

                        COB

                   

               

                0.100:

    0:

    2004-07-22+04:00:

    2004-07-22T00:00:00+04:00:

    whinbr:

    FUKUDA:

    ACTIVE:

    CONSUMER FINANCE:

    Japan:

    TOKYO:

   Single Name:

   TOKYO:

   Official:

3Y: 0: 101.000000000000: 02Y: 0: 89.000000000000: 06M: 0: 65.000000000000: 030Y: 0: 245.000000000000: 04Y: 0: 113.000000000000: 015Y: 0: 215.000000000000: 07Y: 0: 155.000000000000: 09Y: 0: 185.000000000000: 06Y: 0: 140.000000000000: 05Y: 0: 125.000000000000: 012M: 0: 77.000000000000: 08Y: 0: 170.000000000000: 010Y: 0: 200.000000000000: 020Y: 0: 230.000000000000: 0

 

But what I required is :

 

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:3Y::0:101.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:2Y:0:89.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:6M:0:65.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:30Y:0:245.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:4Y:0:113.000000000000:0

 

You can observe one in the expected out file , for every < SourcedPoint> we should repeat the < CurveLevelInfo>

 

Please Help me.

 

 

With Regards,

Bhaskar

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 5:48 PM
To: K S Bhaskar -ICEXT; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Answer- XSLT

 

Bhaskar,

 

I solved the Problem and I tested with XSLT Transformer its working fine, take this

 

 

<?xml version=”1.0” encoding=”UTF-8”?>

 

<xsl:stylesheet version=”1.0” xmlns:xsl=http://www.w3.org./1999/XSL/Transform>

 

<xsl:output method=”xml” version=”1.0” encoding=”UTF-8” indent=”yes”/>

 

<xsl:template match=”Curve”>

 

 

    <xsl:value-of select=”CurveLevelInfo/RecoveryRate”>:

 

    <xsl:value-of select=”CurveLevelInfo/Liquidity”>:

 

    <xsl:value-of select=”CurveLevelInfo/DefaultedDate”>:

 

    <xsl:value-of select=”CurveLevelInfo/LastUpdate”>:

 

    <xsl:value-of select=”CurveLevelInfo/Trader”>:

 

    <xsl:value-of select=”CurveLevelInfo/Status”>:

 

    <xsl:value-of select=”CurveLevelInfo/Sector”>:

 

    <xsl:value-of select=”CurveLevelInfo/Country”>:

 

    <xsl:value-of select=”CurveLevelInfo/Region”>:

 

   <xsl:value-of select=”CurveLevelInfo/CurveType”>:

 

   <xsl:value-of select=”CurveLevelInfo/Book”>:

 

   <xsl:value-of select=”CurveLevelInfo/Source”>::

 

<xsl:for-each select=”SourcedPoint”>

 

           <xsl:value-of select=”Tenor”>: <xsl:value-of select=” BidDate”>:: <xsl:value-of select=”MidDate”>: <xsl:value-of select=” OfferDate”>

 

</xsl:for-each>

 

</xsl:template>

 

</xsl:stylesheet>

 

regards

Jerald S

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 3:10 PM
To: Jerald Selvaraj (WT01 - FINANCE - SECURITIES)
Subject: RE: Please help in XSLT

 

Hi Jerald,

 

            I am sending the XML format and expected output format.

            XML content:

 

            <Curve>

                    <CurveLevelInfo>

                        <RecoveryRate>0.100</RecoveryRate>

                        <Liquidity>0</Liquidity>

                        <DefaultedDate>2004-07-22+04:00</DefaultedDate>

                        <LastUpdate>2004-07-22T00:00:00+04:00</LastUpdate>

                        <LastUpdateUser>whinbr</LastUpdateUser>

                        <Trader>FUKUDA</Trader>

                        <Status>ACTIVE</Status>

                        <Sector>CONSUMER FINANCE</Sector>

                        <Country>Japan</Country>

                        <Region>TOKYO</Region>

                        <CurveType>Single Name</CurveType>

                        <Book>TOKYO</Book>

                        <Source>Official</Source>

                    </CurveLevelInfo>

                    <SourcedPoint methodology="3">

                        <Tenor>3Y</Tenor>

                        <BidRate>0</BidRate>

                        <MidRate>101.000000000000</MidRate>

                        <OfferRate>0</OfferRate>

                    </SourcedPoint>

                    <SourcedPoint methodology="3">

                        <Tenor>2Y</Tenor>

                        <BidRate>0</BidRate>

                        <MidRate>89.000000000000</MidRate>

                        <OfferRate>0</OfferRate>

                    </SourcedPoint>

                    <SourcedPoint methodology="3">

                        <Tenor>6M</Tenor>

                        <BidRate>0</BidRate>

                        <MidRate>65.000000000000</MidRate>

                        <OfferRate>0</OfferRate>

                    </SourcedPoint>

                    <SourcedPoint methodology="3">

                        <Tenor>30Y</Tenor>

                        <BidRate>0</BidRate>

                        <MidRate>245.000000000000</MidRate>

                        <OfferRate>0</OfferRate>

                    </SourcedPoint>

                    <SourcedPoint methodology="3">

                        <Tenor>4Y</Tenor>

                        <BidRate>0</BidRate>

                        <MidRate>113.000000000000</MidRate>

                        <OfferRate>0</OfferRate>

                    </SourcedPoint>

     </curve>

 

Expected output is :

 

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:3Y::0:101.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:2Y:0:89.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:6M:0:65.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:30Y:0:245.000000000000:0

0.100:0:2004-07-22+04:00:2004-07-22T00:00:00+04:00:whinbr:FUKUDA:ACTIVE:CONSUMER FINANCE:Japan:TOKYO:Single Name:TOKYO:Official:4Y:0:113.000000000000:0

 

Here every repeat of tag <SourcePoint> and have append the content of tag <CurveLevelInfo>.

What you have sent is not working.

 

Please help me.

 

Thanks in advance.

 

Regards,

Bhaskar

 

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 2:52 PM
To: K S Bhaskar -ICEXT
Subject: Please help in XSLT

 

Bhaskar,

 

I hope the following code will fulfill your needs

 

<xsl:for-each select =”a”>

       <xsl:value-of select=”b”>

          <xsl:for-each select=”c”>

                  <xsl:value-of select=”I”/> : <xsl:value-of select=”j”/>

          </xsl:for-each>

</xsl:for-each>        

 

Regards

Jerald S

                    

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 2:30 PM
To: [EMAIL PROTECTED]
Subject: Please help in XSLT

 

Hi Everybody,

            Please help.

            I have a XML file in that I have parent tags and two child tag.

Example :

                        <a>

                                    <b>

                                   

                                    </b>

 

                                    <c>

                                                <i>   </i>

                                                <j>   </j>          

           

                                   

                                    </c>

                                                <i>   </i>

                                                <j>   </j>

                                    <c>

                                                <i>   </i>

                                                <j>   </j>

                                    </c>

                        </a>

 

I need XSLT solutions to:

            1) How I can implement, every repeat of <c> I have to combine the content of <b>.

            2) How I can display the content of <i> and <j> in a single row with ‘:’ colon as delimiter.

 

Thanks in advance

 

Bye,

Bhaskar

 

 

           

DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.
Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.

Reply via email to