Update xml attribute values using xmlStarlet

Question

        <?xml version="1.0"?>
<Student xmlns="http://www.tibco.com/schemas/TrainingPOCs/SharedRec/Schemas/Schema.xsd">
  <Phno type="kwh" value="70" name=""/>
  <Phno type="wh" value="100" name="80">
    <Type>D</Type>
    <Mobile>7777777777</Mobile>
    <TPhone>6666666666</TPhone>
  </Phno>
  <Phno type="kwh" value="200" name="">
    <Type>E</Type>
    <Mobile>5555555555</Mobile>
    <TPhone>4444444444</TPhone>
  </Phno
</Student>

My input file need to update name attribute with value attribute value wherever type attribute has kWh Scripts i worked on

xmlstarlet edit -N w="http://www.tibco.com/schemas/TrainingPOCs/SharedRec/Schemas/Schema.xsd" -u "/w:Student/w:Phno[@type='kwh']/@name" -x "/w:Student/w:Phno[@type='kwh']/@value" sample.xml

urznow · Accepted Answer · 2022-01-06 10:22:51Z

1

You're almost there but use a relative XPath expression for the -x / --expr option:

xmlstarlet edit \
    -N w='http://www.tibco.com/schemas/TrainingPOCs/SharedRec/Schemas/Schema.xsd' \
    -u '/w:Student/w:Phno[@type="kwh"]/@name' \
    -x 'string(../@value)' file.xml

Alternatively, using the the default namespace shortcut,

xmlstarlet ed -u '/_:Student/_:Phno[@type="kwh"]/@name' -x 'string(../@value)' file.xml

and perhaps adding an -L / --inplace option (see xmlstarlet.txt) for in-place editing.

answered Jan 6, 2022 at 10:22

urznow

1,8711 gold badge7 silver badges19 bronze badges

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

1 Comment

shiva nagarjuna Over a year ago

Thank you so much @urcodebetterznow it's working well now.

Collectives™ on Stack Overflow

Update xml attribute values using xmlStarlet

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related