xsl: Copy the entire xml except a parent node but keep its child node

Question

HI, I'm new with stylesheets and looking for a solution to copy the entire XML document but remove a parent node from an xml document. However this parent node also has a child that i'd like to keep.

The node to remove is <LoginID> and the child node to keep is <PAN>

<InqRs>
   <LoginID>
     <PAN>4506445</PAN>
   </LoginID>
   <RqUID>93</RqUID>
   <Dt>90703195116</Dt>
   <CaptureDate>704</CaptureDate>
   <ApprovalCode>934999</ApprovalCode>
   <StatusCode>000</StatusCode>
   <List>
   <Count>9</Count>
   <AddDataFlag>N</AddDataFlag>
   <Use>C</Use>
   <DetRec>
   <ID>007237048637</ID>
   <Type1>62</Type1>
   <Qual />
   <ID>0010</ID>
   <Status>1</Status>
   <InqFlag>Y</InqFlag>
   </DetRec>
   </List>
 </InqRs>

Thanks

Answer 1

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;
  <xsl:template match="LoginID">
    <xsl:apply-templates select="PAN"/>
  </xsl:template>
  <xsl:template match="*">
   <xsl:copy><xsl:apply-templates/></xsl:copy>
  </xsl:template>
</xsl:stylesheet>

Answer 2

from that code if you want to remove the node InqRs just apply the following xsl :

<xsl:output method="xml"/>
<xsl:template match="node()">
    <xsl:copy>
        <xsl:copy-of select="@*"/>
        <xsl:apply-templates/>
    </xsl:copy>
</xsl:template>

<xsl:template match="PAN">
    <LoginID>
           <xsl:copy-of select="."/>
    </LoginID>
</xsl:template>

you will get something like this

<InqRs>
    <LoginID> 
        <PAN> 4506445 </PAN>           
    </LoginID>
    <RqUID>93</RqUID>
    <Dt>90703195116</Dt>
    <CaptureDate>704</CaptureDate>
    <ApprovalCode>934999</ApprovalCode>
    <StatusCode>000</StatusCode>
    <List> 
         <Count>9</Count> 
         <AddDataFlag>N</AddDataFlag> 
         <Use>C</Use> 
         <DetRec> 
             <ID>007237048637</ID> 
             <Type1>62</Type1>
             <Qual/> 
             <ID>0010</ID> 
             <Status>1</Status> 
             <InqFlag>Y</InqFlag> 
         </DetRec> 
    </List>
<InqRs>

I hope this help you

Answer 3

Thanks for the quick replies... I'm been playing around with both solutions. What would you do if i had the following data and i wanted to now add the parent node LoginID back

<InqRs> 
   <PAN>4506445</PAN> 
   <RqUID>93</RqUID> 
   <Dt>90703195116</Dt> 
   <CaptureDate>704</CaptureDate> 
</InqRs>

<-- Wanted results -->

<InqRs> 
    **<LoginID>** 
        <PAN> 4506445 </PAN> 
    **</LoginID>** 
    <RqUID>93</RqUID> 
    <Dt>90703195116</Dt> 
    <CaptureDate>704</CaptureDate> 
 </InqRs>

Thanks