Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with missing XML tag
Top Forums Shell Programming and Scripting Help with missing XML tag Post 302961534 by Don Cragun on Monday 30th of November 2015 09:34:34 PM
Old 11-30-2015
This seems to work:
Code:
awk -v DMI="PB00000000123456789" '
/<Membership>/ {
	MIfound = 0
}
/<MembershipIdentifier>/ {
	MIfound = 1
}
/<\/Membership>/ && !MIfound {
	print "        <MembershipIdentifier>" DMI "</MembershipIdentifier>"
}
1' filenames

If a file named filenames contains:
Code:
......
 <Account>
    <AccountIdentifier>23123</AccountIdentifier>
    <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
    <MembershipInfos>
      <Membership>
        <ParticipationStatus>1</ParticipationStatus>
        <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
        <EnrollmentDate>2015-11-26T13:01:22-07:00</EnrollmentDate>
        <MembershipIdentifier>PB00000000212799753</MembershipIdentifier>
      </Membership>
      <Aliases>
	  ....
      </Aliases>
    </MembershipInfos>
  </Account>
  <Account>
......
......
 <Account>
    <AccountIdentifier>23123</AccountIdentifier>
    <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
    <MembershipInfos>
      <Membership>
        <ParticipationStatus>1</ParticipationStatus>
        <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
        <EnrollmentDate>2015-11-26T13:01:22-07:00</EnrollmentDate>
      </Membership>
      <Aliases>
	  ....
      </Aliases>
    </MembershipInfos>
  </Account>
  <Account>
......

the above script produces the output:
Code:
......
 <Account>
    <AccountIdentifier>23123</AccountIdentifier>
    <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
    <MembershipInfos>
      <Membership>
        <ParticipationStatus>1</ParticipationStatus>
        <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
        <EnrollmentDate>2015-11-26T13:01:22-07:00</EnrollmentDate>
        <MembershipIdentifier>PB00000000212799753</MembershipIdentifier>
      </Membership>
      <Aliases>
	  ....
      </Aliases>
    </MembershipInfos>
  </Account>
  <Account>
......
......
 <Account>
    <AccountIdentifier>23123</AccountIdentifier>
    <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
    <MembershipInfos>
      <Membership>
        <ParticipationStatus>1</ParticipationStatus>
        <ModificationDate>2015-11-26T13:01:22-07:00</ModificationDate>
        <EnrollmentDate>2015-11-26T13:01:22-07:00</EnrollmentDate>
        <MembershipIdentifier>PB00000000123456789</MembershipIdentifier>
      </Membership>
      <Aliases>
	  ....
      </Aliases>
    </MembershipInfos>
  </Account>
  <Account>
......

adding the line marked in red.

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
This User Gave Thanks to Don Cragun For This Post:
VasuKukkapalli
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to get xml tag..

Sorry to trouble you guys again.....but i encounter this problem: My textfile contains this: 2006-01-12 01:12:08,290 INFO - The XML message **************<PM_ARRIVAL xmlns:xsi= "http://www.w3.org/2001/XMLSchemainstance"><system_c>GMS</system_c><trans_c>ARLC</trans_c></<PM_ARRIVAL> 2006-01-12... (8 Replies)
Discussion started by: forevercalz
8 Replies

2. Shell Programming and Scripting

XML tag replacement from different XML file

We have 2 XML file 1. ORIGINAL.xml file and 2. ATTRIBUTE.xml files, In the ORIGINAL.xml we need some modification as <resourceCode>431048</resourceCode>under <item type="Manufactured"> tag - we need to grab the 431048 value from tag and pass it to database table in unix shell script to find the... (0 Replies)
Discussion started by: balrajg
0 Replies

3. Shell Programming and Scripting

How to retrieve the value from XML tag whose end tag is in next line

Hi All, Find the following code: <Universal>D38x82j1JJ </Universal> I want to retrieve the value of <Universal> tag as below: Please help me. (3 Replies)
Discussion started by: mjavalkar
3 Replies

4. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

5. Shell Programming and Scripting

XML Parse between to tag with upper tag

Hi Guys Here is my Input : <?xml version="1.0" encoding="UTF-8"?> <xn:MeContext id="01736"> <xn:VsDataContainer id="01736"> <xn:attributes> <xn:vsDataType>vsDataMeContext</xn:vsDataType> ... (12 Replies)
Discussion started by: pareshkp
12 Replies

6. Shell Programming and Scripting

Need to replace XML TAG

As per the requirement I need to replace XML tag with old to new on one of the XML file. Old<com : DEM>PHI</com : DEM> New<com : DEM>PHM</com : DEM> Please someone provide the sed command to replace above mentioned old XML tag with new XML tag (2 Replies)
Discussion started by: siva83
2 Replies

7. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>... (9 Replies)
Discussion started by: srkmish
9 Replies

8. Shell Programming and Scripting

Need help in adding missing tag in php pages

hi, I am still a newbie on ssh but trying hard. my friends website was hit by some virus which included a long encrypted malware code on each and every php file she had. I was able to use sed command via ssh to remove the malware codes but now most pages don't have a opening <?php tag. i... (8 Replies)
Discussion started by: netatma
8 Replies

9. Shell Programming and Scripting

Moving XML tag/contents after specific XML tag within same file

Hi Forum. I have an XML file with the following requirement to move the <AdditionalAccountHolders> tag and its content right after the <accountHolderName> tag within the same file but I'm not sure how to accomplish this through a Unix script. Any feedback will be greatly appreciated. ... (19 Replies)
Discussion started by: pchang
19 Replies

10. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies
All times are GMT -4. The time now is 10:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy