How to write a bash script that can parse through an XML file as input and remove certain elements from the file

Question

I need to create a bash script that manipulates the following sample xml file:

check for a particular ID and remove that XML branch for that ID.

the ID's are read from a text file.

<?xml version="1.0"?>
<cmtf xmlns="urn:RM_UPMS_CMTFEnvelopeSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<data xmlns="">
<entitygroup entityname="people">
  <PERSON xmlns="abc">
    <ID ns="">12280</ID>
    <PIN xmlns="">erererre</PIN>
    <NAME xmlns="">ereffdef</NAME>
  </PERSON>
  <PERSON xmlns="bbc">
    <ID ns="">5567</ID>
    <PIN xmlns="">erererre</PIN>
    <NAME xmlns="">ereffdef</NAME>
  </PERSON>
  <PERSON xmlns="bbc">
    <ID ns="">3347</ID>
    <PIN xmlns="">ededed</PIN>
    <NAME xmlns="">rtreer</NAME>
  </PERSON>
  <PERSON xmlns="bbc">
    <ID ns="">3249</ID>
    <PIN xmlns="">erererre</PIN>
    <NAME xmlns="">ereffdef</NAME>
  </PERSON>
</entitygroup>
</data>
</cmtf>

Here, I need to remove all the <PERSON> tag for all the entries that have the ID 12280, 3249 which is being read from a text file.

xml-sed, part of xml-coreutils may be your friend to perform simple operations on XML files. — Didier Trosset
– Didier Trosset, Commented Aug 8, 2013 at 11:43

Community · Accepted Answer · 2017-05-23 12:28:54Z

0

Perhaps you could use php like this: running php script (php function) in linux bash

And then you something like domdocument(http://php.net/manual/en/class.domdocument.php) to read and the right the xml.

Of course this is assumes you have php installed.

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Aug 8, 2013 at 11:36

matpol

3,0741 gold badge16 silver badges20 bronze badges

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

Comments

hek2mgl · Accepted Answer · 2013-08-08 11:44:09Z

0

You can use XSLT for that. Create an xsl stylesheet which transform the input xml into the desired output. On the console you can use xsltproc (from xmllint package):

 xsltproc stylesheet.xsl input.xml

answered Aug 8, 2013 at 11:44

hek2mgl

159k31 gold badges263 silver badges280 bronze badges

Comments

Charles Duffy · Accepted Answer · 2014-02-18 16:45:56Z

0

This reads a series of IDs to delete from a file input_file, and creates an output.xml based on input.xml with those entries deleted:

ed_commands=( )
while read -r num_to_delete; do
  ed_commands+=( -d "//PERSON[./ID=$num_to_delete]"
done <input_file

xmlstarlet ed "${ed_commands[@]}" <input.xml >output.xml

Note that it requires XMLStarlet.

answered Feb 18, 2014 at 16:45

Charles Duffy

299k43 gold badges442 silver badges498 bronze badges

Collectives™ on Stack Overflow

How to write a bash script that can parse through an XML file as input and remove certain elements from the file

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related