linux shell: sed replace value in xml

Question

I have a xml file, I want to repace the text value in the tag < jdbcurl > with another value, but there are two tags named with jdbcurl nested in different pool id.

Can any one do me a favor to dig it with SED? Thanks.

<?xml version="1.0" ?>
  <WEBServer fileName="webdb.xml" name="Configuration and Security File">
  <security>
  <pool id="DEFAULT" jndiName="jdbc/webdb">
     <dbschema></dbschema>
     <userID>DBUSER</userID>
     <password>passwd1</password>
     <jdbcdriver>oracle.jdbc.driver.OracleDriver</jdbcdriver>
     <jdbcurl>jdbc:oracle:thin:@db.server.com:1753/ORCSN</jdbcurl>
  </pool>
   <pool id="bi_id" jndiName="jdbc/bidb">
    <dbschema></dbschema>
    <userID>BIUSER</userID>
    <password>passwd2</password>
    <jdbcdriver>oracle.jdbc.driver.OracleDriver</jdbcdriver>
    <jdbcurl>jdbc:oracle:thin:@db.server.com:1753/ORCSN</jdbcurl>
  </pool>
 </security>
 </WEBServer>

elaborate what `< jdbcurl >` value should be replaced. Should it depend on `pool id` or what? — RomanPerekhrest, Jan 16 '18 at 09:45
Two words: Don't. [Don't.](https://stackoverflow.com/questions/1732348/regex-match-open-tags-except-xhtml-self-contained-tags/1732454#1732454) — tripleee, Jan 16 '18 at 11:09

Shen Yudong · Accepted Answer · 2018-01-16T09:55:14.453

1

sed -E '/bi_id/,/pool/  s/jdbc:[^<]*/you will replace/g' filename

this one will replace jdbc in pool with id='bi_id'

sed -E '/DEFAULT/,/pool/  s/jdbc:[^<]*/you will replace/g'

this is for DEFAULT pool's jdbcurl

edited Jan 16 '18 at 09:55

answered Jan 16 '18 at 09:46

Shen Yudong

1,190
7
14

score 1 · Answer 2 · answered Jan 16 '18 at 19:14

With xmlstarlet:

xmlstarlet edit --update '//WEBServer/security/pool[@id="DEFAULT"]/jdbcurl' --value 'XYZ' file.xml

Output:

<?xml version="1.0"?>
<WEBServer fileName="webdb.xml" name="Configuration and Security File">
  <security>
    <pool id="DEFAULT" jndiName="jdbc/webdb">
      <dbschema/>
      <userID>DBUSER</userID>
      <password>passwd1</password>
      <jdbcdriver>oracle.jdbc.driver.OracleDriver</jdbcdriver>
      <jdbcurl>XYZ</jdbcurl>
    </pool>
    <pool id="bi_id" jndiName="jdbc/bidb">
      <dbschema/>
      <userID>BIUSER</userID>
      <password>passwd2</password>
      <jdbcdriver>oracle.jdbc.driver.OracleDriver</jdbcdriver>
      <jdbcurl>jdbc:oracle:thin:@db.server.com:1753/ORCSN</jdbcurl>
    </pool>
  </security>
</WEBServer>

Thanks Cyrus. The xmlstarlet script looks clear and easy to understand. — meadlai, Jan 17 '18 at 01:20

linux shell: sed replace value in xml

2 Answers2