Set bash variables from XML tags

Question

I have the following xml file

<root> <deviceID>IO238470374109730497</devicdeID> <KeyValuePairs> <KeyValuePair> <BASE-URL>site.com</BASE-URL> <Key>329482</Key> <Value>23094</Value> </KeyValuePair> <KeyValuePair> <BASE-URL>anothersite.com</BASE-URL> <Key>36657</Key> <Value>1233</Value> </KeyValuePair> <KeyValuePair> <BASE-URL>yetanothsite.com</BASE-URL> <Key>3345</Key> <Value>65087</Value> </KeyValuePair> </KeyValuePairs> </root>

I would like to extract the values of all <BASE-URL>,<Key>,<Value> and set them to variables in a bash script.

executing this command will only print the values

xmlstarlet sel -t -m '//KeyValuePair' -v 'concat(BASE-URL," ", Key, " ", Value, " ")' -nl file.xml

How can I set these values to variables?

I want to extract the values from the xml and send them to variables like this <BASE-URL> to $base_url , <Key> to $key and <Value> to $value.

What variable names do you expect? (site.com is not a valid variable name) — Jeff Schaller
– Jeff Schaller ♦, Commented Feb 13, 2019 at 14:30
I want to extract the values from the xml and send them to varialbles like this <BASE-URL> to $base-url , <Key> to $key and <Value> to $value — Mustafa W Alani
– Mustafa W Alani, Commented Feb 13, 2019 at 14:40
can you suggest valid names please.. anything that do the trick. — Mustafa W Alani
– Mustafa W Alani, Commented Feb 13, 2019 at 14:43
A word consisting solely of letters, numbers, and underscores, and beginning with a letter or underscore. Names are used as shell variable and function names — Jeff Schaller
– Jeff Schaller ♦, Commented Feb 13, 2019 at 14:43

Bodo · Accepted Answer · 2019-02-13 14:43:48Z

2

Assuming the values never contain spaces you can do something like this:

xmlstarlet sel -t -m '//KeyValuePair' -v 'concat(BASE-URL," ", Key, " ", Value, " ")' -nl file.xml | while read base_url key value
do
    echo "base_url=$base_url key=$key value=$value"
done

answered Feb 13, 2019 at 14:43

Bodo

6,44118 silver badges30 bronze badges

It works.. you saved my day.. thank you very much!

Mustafa W Alani
– Mustafa W Alani

2019-02-13 14:56:40 +00:00
Commented Feb 13, 2019 at 14:56

Add a comment |

Stack Exchange Network

Set bash variables from XML tags

1 Answer 1

You must log in to answer this question.

Hot Network Questions

Set bash variables from XML tags

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions