Shell Programming and Scripting

The Problem

I have n files all named "conf.cfg", each of which contain a line that reads: "MyVar=XXX", where XXX can be any value.

I have a second file called report.xml, that might read:
<Reports>
<Report>Report1</Report>
<Report>Report2</Report>
<Report>Report3</Report>
</Reports>

I want to replace everything between the <Reports> tag, with with all the new values I find.

What I have so far:

find . -name conf.cfg | xargs grep -l MyVar= | xargs sed 's/MyVar=*/<Report>/;s/$/<\/Report>/g

This will output for example:

<Report>dog</Report>
<Report>cat</Report>
<Report>mouse</Report>

However, I am unable to take the next logical step and insert that between the <Reports> tag in report.xml.

I tried a whole bunch of things... including

awk '/<Reports>/{p=1;print;print "'"$MyEnvironmentVar"'" }/<\/Reports>/{p=0}!p' report.xml

where $MyVar is the output of the find command... unfortunately, that doesn't work.



I could really use a hand here.

You can do something like that :

Code:

VarName=MyVar

find . -name 'Flang_*.cfg'        |
xargs grep "${VarName}" /dev/null |
awk -v name="${VarName}" '
BEGIN { pattern = "^[^:]*:" name "=" }
NR==FNR {
   sub(pattern, "");
   val[++cnt] = $0;
   next
}
/<Report>/ { next }
/<Reports>/ {
   print;
   for (i=1; i<=cnt; i++) printf "<Report>%s</Report>\n", val[i];
   next;
}
1
' - Flang.xml

Xml input file (Flang.xml) :

Code:

<Doc>
<Reports>
<Report>Report1</Report>
<Report>Report2</Report>
</Reports>
</Doc>

Cfg input files (Flang_*.cfg):

Code:

==> Flang_1.cfg <==
Var=value
MyVar=dog
AnotherVar=empty

==> Flang_2.cfg <==
Init=/home
Color=black
MyVar=cat

==> Flang_3.cfg <==
MyVar=mouse

==> Flang_4.cfg <==
MyVar=horse

Output:

Code:

<Doc>
<Reports>
<Report>dog</Report>
<Report>cat</Report>
<Report>mouse</Report>
<Report>horse</Report>
</Reports>
</Doc>

Jean-Pierre.