[xsl] How to get XSL transform this XML

["Manoj Jha" <manoj_k_jha at hotmail dot com>]

Hi,

I need XSL to transform the following XML. Could some guru help me out ?

Below is a sample XML that I want to transform, and the description of the 
problem:

<?xml version="1.0"?>
<DocumentRequest>
  <Director>
    <DocumentName>UnderwritingAnalysisPage1</DocumentName>
    <DeliveryMedium>browser</DeliveryMedium>
    <ApplicationId>15</ApplicationId>
    <PostPay>no</PostPay>
  </Director>
  <DocumentDetails>
    <BorrowerName>WALZER, CLIFFORD S</BorrowerName>
    <LoanStatus>APPROVED</LoanStatus>
     .
     .
    <ConditionText1>PRIOR TO APPROVAL CONDITIONS - UGSI TO 
REVIEW:</ConditionText1>
    <ConditionText2>     </ConditionText2>
    <ConditionText3>PRIOR TO DOC CONDITIONS - UGSI TO 
REVIEW:</ConditionText3>
    <ConditionText4>     </ConditionText4>
    <ConditionText5>PRIOR TO CLOSING CONDITIONS - UGSI TO 
REVIEW:</ConditionText5>
    <ConditionText6>03/14/2002 _____ THANK YOU FOR CHOOSING UNITED GUARANTY. 
  PLEASE INCLUDE A COPY OF </ConditionText6>
    <ConditionText7>                 THIS</ConditionText7>
     .
     .
    <ConditionText15>CLOSING CONDITIONS:</ConditionText15>
    <ConditionText16>                 X FINAL SIGNED T-I-L</ConditionText16>
    <ConditionText17>                 X FILE MUST CLOSE AS A 30 YEAR 
RATE/TERM REFINANCE</ConditionText17>
     .
     .
    <ConditionText44> </ConditionText44>
  </DocumentDetails>
</DocumentRequest>

The tag value "CLOSING CONDITIONS:" can appear as value of any of the 
ConditionText tags, but after the "PRIOR CONDITIONS".
The XSL stylesheet should locate the "CLOSING CONDITIONS:" value, and insert 
3 new predefined fixed ConditionText nodes after
that node. All the remaining ConditionText nodes will show this change in 
the result tree by having their count incremented as
shown in the transformed XML below:

<?xml version="1.0"?>
<DocumentRequest>
  <Director>
    <DocumentName>UnderwritingAnalysisPage1</DocumentName>
    <DeliveryMedium>browser</DeliveryMedium>
    <ApplicationId>15</ApplicationId>
    <PostPay>no</PostPay>
  </Director>
  <DocumentDetails>
    <BorrowerName>WALZER, CLIFFORD S</BorrowerName>
    <LoanStatus>APPROVED</LoanStatus>
     .
     .
    <ConditionText1>PRIOR TO APPROVAL CONDITIONS - UGSI TO 
REVIEW:</ConditionText1>
    <ConditionText2>     </ConditionText2>
    <ConditionText3>PRIOR TO DOC CONDITIONS - UGSI TO 
REVIEW:</ConditionText3>
    <ConditionText4>     </ConditionText4>
    <ConditionText5>PRIOR TO CLOSING CONDITIONS - UGSI TO 
REVIEW:</ConditionText5>
    <ConditionText6>03/14/2002 _____ THANK YOU FOR CHOOSING UNITED GUARANTY. 
  PLEASE INCLUDE A COPY OF </ConditionText6>
    <ConditionText7>                 THIS</ConditionText7>
     .
     .
    <ConditionText15>CLOSING CONDITIONS:</ConditionText15>
    <ConditionText16>                 X This is Standard Condition 
1</ConditionText16> <!-- These 3 conditions get inserted -->
    <ConditionText17>                 X This is Standard Condition 
2</ConditionText17>
    <ConditionText18>                 X This is Standard Condition 
3</ConditionText18>
    <ConditionText19>                 X FINAL SIGNED T-I-L</ConditionText19> 
           <!-- ConditionText16 now becomes Condition19, and so on; the 
value for the node remains the same -->
    <ConditionText20>                 X FILE MUST CLOSE AS A 30 YEAR 
RATE/TERM REFINANCE</ConditionText20>
     .
     .
    <ConditionText47> </ConditionText47>
  </DocumentDetails>
</DocumentRequest>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list