How can I replace a value based on an element name in my XML file using sed, awk or ideally xmlstartlet

Question

I'm trying to replace the value 10 with the value 5 where testname="TG1"

Change This:

<stringProp name="ThreadGroup.num_threads">10</stringProp>

To This:

 <stringProp name="ThreadGroup.num_threads">5</stringProp>

Snippet Example

Before:

<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="TG1" enabled="true">
    <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
    </elementProp>
    <stringProp name="ThreadGroup.num_threads">10</stringProp>
  </ThreadGroup>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="TG2" enabled="true">
    <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
    </elementProp>
    <stringProp name="ThreadGroup.num_threads">50</stringProp>
  </ThreadGroup>

After:

<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="TG1" enabled="true">
    <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
    </elementProp>
    <stringProp name="ThreadGroup.num_threads">5</stringProp>
  </ThreadGroup>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="TG2" enabled="true">
    <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
    </elementProp>
    <stringProp name="ThreadGroup.num_threads">50</stringProp>
  </ThreadGroup>

glenn jackman · Accepted Answer · 2016-07-02 20:15:28Z

2

Assuming you actually have valid XML, this is really an xpath problem:

xmlstarlet ed \
    --update '//ThreadGroup[@testname="TG1"]//stringProp[@name="ThreadGroup.num_threads"]' \
    --value 5 \
    file.xml

To save the file in place, change ed to ed --inplace

edited Jul 2, 2016 at 20:15

answered Jul 2, 2016 at 20:07

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

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

Comments

F. Knorr · Accepted Answer · 2016-07-02 14:07:57Z

0

Try this awk-command:

awk '$0 ~ "testclass=\"ThreadGroup\"" && $0 ~ "testname=\"TG1\""{replace=1}
     $0 ~ "testclass=\"ThreadGroup\"" && $0 !~ "testname=\"TG1\""{replace=0}
     replace{gsub("name=\"ThreadGroup.num_threads\">10</stringProp>",
                  "name=\"ThreadGroup.num_threads\">5</stringProp>",$0)}1' in.txt

It will replace all name="ThreadGroup.num_threads">10</stringProp> by name="ThreadGroup.num_threads">5</stringProp> if they are within <... testclass="ThreadGroup" testname="TG1" ...>

answered Jul 2, 2016 at 14:07

F. Knorr

3,07518 silver badges22 bronze badges

Comments

Claes Wikner · Accepted Answer · 2016-07-02 20:21:33Z

0

awk '{sub(/10<\/stringProp>/,"5</stringProp>")}1' file

<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="TG1" enabled="true">
    <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
    </elementProp>
    <stringProp name="ThreadGroup.num_threads">5</stringProp>
  </ThreadGroup>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="TG2" enabled="true">
    <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
    </elementProp>
    <stringProp name="ThreadGroup.num_threads">50</stringProp>
  </ThreadGroup>

answered Jul 2, 2016 at 20:21

Claes Wikner

1,5271 gold badge9 silver badges8 bronze badges

Collectives™ on Stack Overflow

How can I replace a value based on an element name in my XML file using sed, awk or ideally xmlstartlet

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related