Editing xml from script

Question

I need to run a user-data script in an ec2-instance that changes an XML in a folder.

I have an XML like this one in a path in the ec2:

<Root>
    <Properties>
       <Property>
          <Name>myProp</Name>
          <Value>old_value</Value>
       </Property>
       <Property>
          <Name>anotherProp</Name>
          <Value>other_value</Value>
       </Property>
    </Propierties>
</Root>

I want to change old_value into new_value. But just that one, not other_value.

How can I do this?

I've tried a powershell script but I don't know how to run it to test it:

#!/bin/bash
$path = '/home/wowza/conf/Server.xml'

$new_value = 'new_value'

$xml = [xml](Get-Content $path)

$xml.Data.Course.Subject

$property = $xml.Root.Server.Properties.Property | where {$_.Name -eq 'myProp'}
$property.Value = $new_value

$xml.Save($path)

Please if you send me a script don't forget to include how to run it to test it, the interpreter for the #! line and what things to install. Thank you!

This might help: Using xmlstarlet, how do I change the value of an element — Cyrus
– Cyrus, Commented Nov 15, 2016 at 20:19

Cyrus · Accepted Answer · 2016-11-15 20:35:32Z

2

With GNU sed:

sed -i '/<Name>myProp<\/Name>/,/<Value>old_value<\/Value>/s/old_value/new_value/' file.xml

Output to file file.xml:

<Root>
    <Properties>
       <Property>
          <Name>myProp</Name>
          <Value>new_value</Value>
       </Property>
       <Property>
          <Name>anotherProp</Name>
          <Value>other_value</Value>
       </Property>
    </Propierties>
</Root>

answered Nov 15, 2016 at 20:35

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

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

2 Comments

Leticia Esperon Over a year ago

This works perfectly!!!!! Thank you. Do you know how I could make it independent of the old_value text? I mean, to get it changed even if old_value is different?

Cyrus Over a year ago

Try this: sed -i '/<Name>myProp<\/Name>/,/<Value>/s/<Value>[^<]*/<Value>new_value/' file.xml or sed -E '/<Name>myProp<\/Name>/,/<Value>/s/(<Value>).*(<\/Value>)/\1new_value\2/' file.xml

Jamil Said · Accepted Answer · 2016-11-16 01:24:07Z

1

The code below will allow you to set the new_value for the targeted field even if you don't know what the old_value is:

#!/bin/bash

sed -i -e '/<Name>myProp<\/Name>/,/<Value>/s/^\s*<Value>.*$/<Value>new_value<\/Value>/' /folder/xml-file

The only caveat here is that the script will strip white space indentations from the line to be changed, but that is only a visual thing that does not affect the code result; you can add the indentation spaces you need afterwards with another sed command, if that is important to you.

answered Nov 16, 2016 at 1:24

Jamil Said

2,1433 gold badges18 silver badges18 bronze badges

2 Comments

Leticia Esperon Over a year ago

Do you know how I could make it independent of the old_value text? I mean, to get it changed even if old_value is different?

Jamil Said Over a year ago

The code above already does that - it will change the value of the targeted field regardless of what the old_value is (and you do not need to refer to the old_value anywhere). Just change the new_value on the code above to whatever you want to update the value to.

Collectives™ on Stack Overflow

Editing xml from script

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related