bash extract xml attribute value using xmllint

Question

I am extracting an attribute value from xml file, but I get an error. I'd like to extract the value for key="qua" in the firstpart element. Here is my script, but below you find the errors:

#!/bin/bash

myfile=$1

myvar=$(echo 'cat //firstpart/step/category/id/info[@key="qua"]/@value' | xmllint --xpath "$myfile" | awk -F'[="]' '!/>/{print $(NF-1)}')

echo "$myvar"

how my xml file looks like:

<?xml version='1.0' encoding='UTF-8'?>
<firstpart>
    <step name="Home">    
        <category name="one">
            <id name="tools">
                <info key="qua" value="1"/>        
            </id>
        </category>
    </step>
    <step name="Contact">    
        <category name="two">
            <id name="tools">
                <info key="qua" value="2"/>        
            </id>
        </category>
    </step>
    ...
</firstpart>
<secondpart>
    <step name="office">    
        <category name="one">
            <id name="tools">
                <info key="qua" value="100"/>        
            </id>
        </category>
    </step>
    <step name="Contact">    
        <category name="two">
            <id name="tools">
                <info key="qua" value="200"/>        
            </id>
        </category>
    </step>
    ...
</secondpart>

the errors I get:

awk: run time error: negative field index $-1
    FILENAME="-" FNR=71 NR=71

./mybash.sh: line 3: $: command not found
./mybash.sh: line 4: $: command not found

Have you tried saving the xmllint output to a file and running awk on that? I assume not since your problem will be extremely obvious if you do. — Ed Morton
– Ed Morton, Commented May 9, 2017 at 13:08
@EdMorton how can i do it? could you provide an answer please? — passion
– passion, Commented May 9, 2017 at 13:09
Instead of piping to awk, redirect to a file. Then run awk on that file and get the same error. Then inspect the file to see the problem. — choroba
– choroba, Commented May 9, 2017 at 13:16
@Cyrus why is it not a valid one? i have excluded the tail of the file and included three dots in the middle to say that they are other stuff there... — passion
– passion, Commented May 9, 2017 at 13:29

Bor Laze · Accepted Answer · 2017-05-09 14:12:50Z

4

It looks like you call xmllint in wrong way.

xmllint --xpath '//firstpart/step/category/id/info[@key="qua"]/@value' FILE.xml

Result:

value="1" value="2"

Complete script:

#!/bin/bash

str=$(xmllint --xpath '//firstpart/step/category/id/info[@key="qua"]/@value' $1)

entries=($(echo ${str}))
for entry in "${entries[@]}"; do
    result=$(echo $entry | awk -F'[="]' '!/>/{print $(NF-1)}')
    echo "result: $result"
done

May be, it's not better solution, but at least it works :)

edited May 9, 2017 at 14:12

answered May 9, 2017 at 13:38

Bor Laze

2,52614 silver badges20 bronze badges

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

1 Comment

passion Over a year ago

how can i get the value only and not the ` value="1"` ? on the the number

Cyrus · Accepted Answer · 2017-05-09 14:24:48Z

3

Get value of attribute with xmllint:

xmllint --xpath 'string(//firstpart/step[1]/category/id/info/@value)' file.xml

Output:

edited May 9, 2017 at 14:24

answered May 9, 2017 at 14:15

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

1 Comment

passion Over a year ago

I like this solution but since Bor laze was first to answer, so I accept that one as the answer to the question.

Collectives™ on Stack Overflow

bash extract xml attribute value using xmllint

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related