Shell script to extract value for a variable from XML response

Question

I have a XML response from which I need to extract the value of ObjDevice whenever the BillPlan="UBM - A/A". Can you please help me with a shell script to do the same

    <Txn>
            <TxnName>Spectrum-AlertSite-Component_spectrum.engprod_InstantUpgradeEdge_GetProductOffersByAccount_getProductOffersByAccountValid</TxnName>
            <TxnDetail Monitor="y" Notify="y" PingError="n"
  TraceError="y" Interval="5" TimeOut="300"
  ObjDevice="318373" BillPlan="UBM - A/A" MaxSteps="50"

 />
        </Txn>
        <Txn>
            <TxnName>Spectrum-AlertSite-Component_spectrum.engprod_InstantUpgradeEdge_GetProductOffersByAccount_getProductOffersByAccountValid</TxnName>
            <TxnDetail Monitor="y" Notify="y" PingError="n"
  TraceError="y" Interval="5" TimeOut="300"
  ObjDevice="318377" BillPlan="UBM - A/A" MaxSteps="50"

 />

Have you looked at any of the other "how do I extract a value from an XML document in shell" questions? — Charles Duffy
– Charles Duffy, Commented Jun 14, 2016 at 20:24

kcoder24 · Accepted Answer · 2016-06-15 15:50:11Z

1

Well if you don't have a special tool to handle XML files and you always have in the same line both values then you can execute:

grep 'BillPlan="UBM - A/A"' | sed 's,.*ObjDevice="\([0-9]*\)" BillPlan="UBM - A/A".*,\1,"

Sorry if I don't use sed to filter but not so familiar with sed and also don't have access to a *nix, but maybe somebody else can give us the short version

edited Jun 15, 2016 at 15:50

answered Jun 14, 2016 at 21:05

kcoder24

19610 bronze badges

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

1 Comment

Walter A Over a year ago

In your sed command you should start with a s or combine it to sed -ne '/BillPlan="UBM - A\/A"/s,.*ObjDevice="\([0-9]*\)" BillPlan="UBM - A/A".*,\1,p'

Charles Duffy · Accepted Answer · 2016-06-14 20:26:01Z

1

Using XMLStarlet:

xmlstarlet sel -t -m '//TxnDetail[@BillPlan="UBM - A/A"]' \
                  -v ./@ObjDevice -n \
  <in.xml

answered Jun 14, 2016 at 20:26

Charles Duffy

299k43 gold badges440 silver badges495 bronze badges

Comments

BeniBela · Accepted Answer · 2016-06-14 20:33:07Z

1

With my Xidel you can do:

xidel /tmp/foo.xml -e '//TxnDetail[@BillPlan="UBM - A/A"]/@ObjDevice'

answered Jun 14, 2016 at 20:33

BeniBela

17.1k4 gold badges48 silver badges55 bronze badges

Comments

Jürgen Hötzel · Accepted Answer · 2016-06-14 21:06:36Z

1

I asume libxml2 is installed (quite likely on any GNU/Linux system):

xmllint --xpath '//TxnDetail[@BillPlan="UBM - A/A"]/@ObjDevice' input.xml

answered Jun 14, 2016 at 21:06

Jürgen Hötzel

19.9k3 gold badges44 silver badges59 bronze badges

Collectives™ on Stack Overflow

Shell script to extract value for a variable from XML response

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related