Search code examples
xmlbashxmllint

Display multiple elements of an XML

I have an xml file with multiple elements with the same key elements with the same name. I'm trying to concatonate the sub elements but can only get the first occurrence.

<?xml version="1.0" encoding="utf-8"?>
<FOLDER JOBNAME="some Job"  MAXWAIT="5">
    <OTHER>
        <ELEMENTS>
        </ELEMENTS>
    </OTHER>
</FOLDER>
<FOLDER JOBNAME="some Other Job"  MAXWAIT="15">
    <OTHER>
        <ELEMENTS>
        </ELEMENTS>
    </OTHER>
</FOLDER>

Is there a way to use xmllint or some other tool to get output like:

some Job 5
some Other Job 15
etc...

when I try with xmllint --xpath, I get the following:

me@myComp tmp $ xmllint --xpath 'concat(//@JOBNAME," ",//@MAXWAIT)' jobs.xml
ADDRESS_VERIFICATION 5
me@myComp tmp $ xmllint --xpath 'concat(//JOBNAME[*]," ",//MAXWAIT[*])' jobs.xml
 
me@myComp tmp $

Is there a way to concatenate multiple parameters with xmllint or any other tool on the command line?

UPDATE - Yeah, it's a proper XML - Also, just notices the repeated lines and removed them.

Solution

  • You may find the XML parser interesting:

    $ xidel -s jobs.xml -e '//FOLDER/concat(@JOBNAME," ",@MAXWAIT)'
$ xidel -s jobs.xml -e '//FOLDER/join((@JOBNAME,@MAXWAIT))'
$ xidel -s jobs.xml -e '//FOLDER/x"{@JOBNAME} {@MAXWAIT}"'   # Xidel's own extended-string-syntax.

    All resulting in:

    some Job 5
some Other Job 15