Click here to Skip to main content
15,887,812 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I am looking for a script which can delete a part of an xml, a complete tag from the xml and save the new result into another xml:
For example, XML below contains 3 parent tags with creditapplicationid:
<CreditApplication ID="1111111">
    <CreditApplicationDetails>
      <DecisionID>11223366</DecisionID>
      <LenderReference>256548</LenderReference>
          </CreditApplicationDetails>
    <CreditApplicationHistoryLogs>
      <Log ID="25486522">
        <Status>FULFILLED</Status>
        <Timestamp>2018-06-02T11:52:05+01:00</Timestamp>
      </Log>
         </CreditApplicationHistoryLogs>
    <ConsumerDetails>
      <Title>Mr</Title>
      <FirstName>ROXY</FirstName>
         </ConsumerDetails>
        <Decision ID="2255222">
      <PolicyName>Credit Strategy V20</PolicyName>
      <DecisionStatus>ACCEPT</DecisionStatus>
      <Timestamp>2018-06-02T11:38:36+01:00</Timestamp>
      <Rule>
        <RuleNumber>1</RuleNumber>
        <RuleName>Applicant over 18 years old</RuleName>
                  </Rule>
              <Rule>
        <RuleNumber>140</RuleNumber>
        <RuleName>Notice of correction found</RuleName>
              </Rule>
    </Decision>
    <CreditSentryData>
            <MobileStatus>1</MobileStatus>
    </CreditSentryData>
  </CreditApplication>
  <CreditApplication ID="2222222">
    <CreditApplicationDetails>
      <DecisionID>25252525</DecisionID>
      <LenderReference>3636365</LenderReference>
          </CreditApplicationDetails>
    <CreditApplicationHistoryLogs>
      <Log ID="454545">
        <Status>FULFILLED</Status>
        <Timestamp>2018-06-02T11:52:05+01:00</Timestamp>
      </Log>
         </CreditApplicationHistoryLogs>
    <ConsumerDetails>
      <Title>Mr</Title>
      <FirstName>AMIT</FirstName>
         </ConsumerDetails>
        <Decision ID="112255874">
      <PolicyName>Credit Strategy V20</PolicyName>
      <DecisionStatus>ACCEPT</DecisionStatus>
      <Timestamp>2018-06-02T11:38:36+01:00</Timestamp>
      <Rule>
        <RuleNumber>1</RuleNumber>
        <RuleName>Applicant over 18 years old</RuleName>
                  </Rule>
              <Rule>
        <RuleNumber>140</RuleNumber>
        <RuleName>Notice of correction found</RuleName>
              </Rule>
    </Decision>
    <CreditSentryData>
            <MobileStatus>1</MobileStatus>
    </CreditSentryData>
  </CreditApplication>
  <CreditApplication ID="33665588">
    <CreditApplicationDetails>
      <DecisionID>558454</DecisionID>
      <LenderReference>669855</LenderReference>
          </CreditApplicationDetails>
    <CreditApplicationHistoryLogs>
      <Log ID="254112">
        <Status>FULFILLED</Status>
        <Timestamp>2018-06-02T11:52:05+01:00</Timestamp>
      </Log>
         </CreditApplicationHistoryLogs>
    <ConsumerDetails>
      <Title>Mr</Title>
      <FirstName>KATY</FirstName>
         </ConsumerDetails>
        <Decision ID="254125">
      <PolicyName>Credit Strategy V20</PolicyName>
      <DecisionStatus>ACCEPT</DecisionStatus>
      <Timestamp>2018-06-02T11:38:36+01:00</Timestamp>
      <Rule>
        <RuleNumber>1</RuleNumber>
        <RuleName>Applicant over 18 years old</RuleName>
                  </Rule>
              <Rule>
        <RuleNumber>140</RuleNumber>
        <RuleName>Notice of correction found</RuleName>
              </Rule>
    </Decision>
    <CreditSentryData>
            <MobileStatus>1</MobileStatus>
    </CreditSentryData>
  </CreditApplication>222">



I want to remove entire information of credit application id 222222
from
<CreditApplication ID="2222222">
to
</CreditApplication>


how can this be achieved using batch script?

Thanks in advance

What I have tried:

I am able to create a script which can delete a particular record from a line but unable to loop it into xml.
Posted
Comments
Hackoo 16-Dec-19 6:08am    
Did you mean that you want to remove this part ? Demo here

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900