Updating text in XML file using a certain node (Shell script)shell

Question

Looking for a way to change the values of node in an xml file using shell.

Example of data in xml file:

<property>

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:postgresql://myhost/metastore</value>

</property>

Based on <name> node, change the text in <value> node. Is it achievable through sed or xmlstarlet.

What I want is like based on <name> = javax.jdo.option.ConnectionURL, change <value> to Banana, so the output would be:

<property>

    <name>javax.jdo.option.ConnectionURL</name>

    <value>Banana</value>

 </property>

Thanks in advance

zx485 · Accepted Answer · 2018-07-23 20:32:09Z

1

With xmlstarlet you can achieve this using the following command:

xmlstarlet ed -u '//property[name="javax.jdo.option.ConnectionURL"]/value' -v newValue source.xml

This sets the new value newValue in the XML of source.xml.

Additional info:
Always use an XML parser to process XML files and not text-based utilities like sed.

answered Jul 23, 2018 at 20:32

zx485

29.1k28 gold badges55 silver badges65 bronze badges

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

1 Answer 1