Extract specific values from XML configuration

Question

Input XML looks like several blocks of:

<Parties>
  <Party compid="CUST1" side="1">
                <Connections>
                    <SocketConnection listenport="9029" />
                </Connections>
   </Party>
</Parties>

My goal is to extract to each customer his specific params like: compid;listenport

By now I can get all customers using

xmlstarlet fo -D config.xml | xmlstarlet select -T -t -m '//Parties/Party' -v '@compid' -nl

Next step would be a loop for each customer to get his listenport, but

xmlstarlet fo -D config.xml | xmlstarlet select -T -t -m '//Parties/Party[@compid="CUST1"]' -v 'Connections/SocketConnection/@listenport'

or any other try returns nothing. Am I missing something at filtering using [@value=string]?

Thanks in advance!

Cyrus · Accepted Answer · 2021-11-27 21:28:36Z

1

With your example and xmlstarlet:

xmlstarlet select --text --template --match '//Parties/Party' --value-of \
  'concat(@compid,";",Connections/SocketConnection/@listenport)' -n config.xml

Output:

CUST1;9029

See: xmlstarlet select --help

edited Nov 27, 2021 at 21:28

answered Nov 27, 2021 at 21:21

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

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

Collectives™ on Stack Overflow

Extract specific values from XML configuration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related