Delete a line from XML file using bash script

Question

I am trying to delete a line from XML file using SED. i.e. sed -i "/Mansing/d" /home/test.xml but it deleting both the lines one with having 'Mansing' and other with 'MansingTest' as in Resource name value. Any help? XML file is as below

<a> <Resource name="Mansing" auth="container" url="jdbc:mysql:"" /> <Resource name="MansingTest" auth="container" url="jdbc:mysql:"" /> <c> <Test>tterer</test> </c> </a>

Use proper xml aware tools like xmlstarlet and not blunt text processing tools. — Inian
– Inian, Commented Nov 28, 2016 at 6:50
What's stopping you from changing the search regex to /\"Mansing\"/? But @Inian has a valid point: Use a proper tool for the job. — Jim Garrison
– Jim Garrison, Commented Nov 28, 2016 at 6:50
I agree with and appreciate your help. Though xmlstarlet does not work at my end, I will find out what module it requires on machine. Thank you — mansing shinde
– mansing shinde, Commented Nov 28, 2016 at 8:38

Cyrus · Accepted Answer · 2016-11-28 06:59:21Z

1

With this syntax fixed file.xml

<a>
    <Resource name="Mansing" auth="container" url="jdbc:mysql:" />
    <Resource name="MansingTest" auth="container" url="jdbc:mysql:" />
    <c>
        <Test>tterer</Test>
    </c>
</a>

and xmlstarlet.

xmlstarlet ed -d '//a/Resource[@name="Mansing"]' file.xml

Output:

<?xml version="1.0"?>
<a>
  <Resource name="MansingTest" auth="container" url="jdbc:mysql:"/>
  <c>
    <Test>tterer</Test>
  </c>
</a>

answered Nov 28, 2016 at 6:59

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

P.... · Accepted Answer · 2016-11-28 06:51:39Z

0

sed  "/\<Mansing\>/d" filename

answered Nov 28, 2016 at 6:51

P....

18.6k3 gold badges36 silver badges55 bronze badges

Collectives™ on Stack Overflow

Delete a line from XML file using bash script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related