How to replace value of xml attributes matching a regex in bash?

Question

I would like to substitute the values of XML attributes matching a regex in a file in bash.

 <Resource name="MailSession" auth="Container" type="javax.mail.Session"
            mail.smtp.host="localhost" mail.smtp.user="foo" mail.smtp.passwd="12345678"
            mail.pop3.host="localhost" mail.pop3.user="foo" mail.pop3.passwd="12345678"/>

should be transformed to

 <Resource name="MailSession" auth="Container" type="javax.mail.Session"
            mail.smtp.host="***" mail.smtp.user="foo" mail.smtp.passwd="***"
            mail.pop3.host="***" mail.pop3.user="foo" mail.pop3.passwd="***"/>

This should be possible using sed or awk.

Possible duplicate of regular expression to replace an xml attribute — tripleee
– tripleee, Commented Oct 18, 2016 at 16:27

konsolebox · Accepted Answer · 2013-09-19 10:55:48Z

4

I'd have my sed command like this:

sed -E 's@(mail[.][^.]+[.])(host|passwd)="[^"]*"@\1\2="***"@g' file

Output:

 <Resource name="MailSession" auth="Container" type="javax.mail.Session"
            mail.smtp.host="***" mail.smtp.user="foo" mail.smtp.passwd="***"
            mail.pop3.host="***" mail.pop3.user="foo" mail.pop3.passwd="***"/>

You can add -i option to sed to directly modify the file.

answered Sep 19, 2013 at 10:55

konsolebox

76.3k13 gold badges110 silver badges114 bronze badges

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

Comments

greuze · Accepted Answer · 2013-09-19 10:38:44Z

1

If your XML file is called "test.xml" you can:

cat test.xml | sed 's/host="[^"]*/host="***/g' | sed 's/passwd="[^"]*/passwd="***/g'

If you are reading the file from other place (such as HTTP connection, or whatever) you can modify the first command of the pipe.

edited Sep 19, 2013 at 10:38

answered Sep 19, 2013 at 10:33

greuze

4,3965 gold badges47 silver badges65 bronze badges

Comments

Jotne · Accepted Answer · 2013-09-19 11:56:51Z

1

Using awk

 awk -F\" '/host/ {$2=$6="***"}1' OFS=\" file
<Resource name="MailSession" auth="Container" type="javax.mail.Session"
            mail.smtp.host="***" mail.smtp.user="foo" mail.smtp.passwd="***"
            mail.pop3.host="***" mail.pop3.user="foo" mail.pop3.passwd="***"/>

answered Sep 19, 2013 at 11:56

Jotne

41.7k13 gold badges54 silver badges58 bronze badges

Collectives™ on Stack Overflow

How to replace value of xml attributes matching a regex in bash?

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