Replace a value in XML

Question

I have a xml tag like below:

<Setting Name="Check" Type="xsd:integer">53</Setting>

I need to fetch only 53 with the best possible code. Can someone suggest?

I know it can be achieved as below:

grep "Setting Name=\"Check\"" abc-test.xml | cut -d'>'  -f 2 |  cut -d'<' -f 1

Thanks

Birei · Answer 1 · 2015-02-02T13:57:33.427

4

I will always suggest an xml parser for this kind of task, like xmlstarlet and using xpath expressions. An example:

xmlstarlet sel -t -v '/Setting[@Name="Check"]/text()' abc-test.xml

that yields:

UPDATE with xmllint version:

xmllint --xpath '/Setting[@Name="Check"]/text()' abc-test.xml

edited Feb 02 '15 at 13:57

answered Feb 02 '15 at 13:35

Birei

But, xmlstarlet is not available on the linux host that am using at all.. Please let me know for any other way – Shankar Guru Feb 02 '15 at 13:48
You can also use `xmllint`, replacing the binary and its arguments but the xpath expression and the input file. But I'm not going to be trying until can find one of your toolbox. It's better you to visit this [how to parse xml from shell](http://stackoverflow.com/questions/4680143/how-to-parse-xml-using-shellscript) and choose one. – Birei Feb 02 '15 at 13:56
I see in my host --xpath for xmllint is not supported..I get the Usage listed Unknown option --xpath Usage : xmllint [options] XMLfiles ... – Shankar Guru Feb 02 '15 at 14:05
2

How to replace the value with something else with xmllint? – Khurshid Alam Nov 24 '16 at 04:27

score 3 · Answer 2 · answered Feb 02 '15 at 22:52

Possible codes are as follows..I don't know if this is the "best" for you.

using sed

sed '/Setting Name="Check"/{s/^[^>]\+>\([0-9]\+\)<.*/\1/g}'

example

echo '<Setting Name="Check" Type="xsd:integer">53</Setting>'|sed '/Setting Name="Check"/{s/^[^>]\+>\([0-9]\+\)<.*/\1/g}'

using awk

   awk -v FS="<[^0-9]+>" '$0~"Setting Name=\"Check\""{print $2}'

example

echo '<Setting Name="Check" Type="xsd:integer">53</Setting>'|awk -v FS="<[^0-9]+>" '$0~"Setting Name=\"Check\""{print $2}'

Skynet · Accepted Answer · 2015-02-03T03:36:18.017

2

With only grep command

grep -oP '(?<=>).*?(?=</Setting>)' input.xml

For extending conditions(i.e.: Check) you can mention elements too like this,

grep "Name=\"Check\"" input.xml|grep -oP '(?<=>).*?(?=</Setting>)'

The output will be,

Here is what I tried,

enter image description here

edited Feb 03 '15 at 03:36

answered Feb 02 '15 at 14:33

Skynet

This is a great command.. Thank you. But problem am facing now is that the above grep is displaying many lines which ends with . Is it possible to please explain the above command? In fact I want to select only line 53 – Shankar Guru Feb 02 '15 at 17:04
1

Thank you.. this actually helped me a lot. I was looking for this :) – Shankar Guru Feb 03 '15 at 05:45
@user1677102 good to know it solved your problem, hope you don't mind accepting this as answer. – Skynet Feb 03 '15 at 05:48
Sure, by all means am accepting this answer :) – Shankar Guru Feb 04 '15 at 05:44

3 Answers3