Shell Programming and Scripting

Hi -

I've seen variations of this same question asked but I have not been able to find an answer that fits my problem. Please direct me to another post if there already is a solution to this.

I'm trying to write a Unix script to dynamically iterate through a flat file and replace a value in an XML when a match is found.
For example:
Flat file contains multiple entries in the format of -

Code:

Application.Env~DEV 
Application.ID~99999

Pre-script XML contains multiple entries in the format of -

Code:

<name>Application/Env</name> 
<value>XXX</value> 
<name>Application/ID</name> 
<value>00000</value>

How do I replace <value> tags in the XML with the text after '~' when the <name> tag matches the part before '~'; Essentially, parsing the flat file based on the tildes. So after running the script I will have

Post-script XML:

Code:

<name>Application/Env</name> 
<value>DEV</value> 
<name>Application/ID</name> 
<value>99999</value>

Any suggestions are appreciated. I don't have code to share, I just need a starting point.

Moderator's Comments:

edit by bakunin: please use CODE-tags as you agreed to do when you accepted the forum rules. Thank you.

Please use code tags as required by forum rules!

Not sure I understand. Text and samples seem somewhat contradictory. Does your flat file contain one or several replacement entries? Which one to use, then? Do you want to replace every occurrence in the XML file with the replacement values? If no, which to replace?

Code tags noted.

Text file contains several entries in the format described and yes the XML will be replaced with every occurrence in the text file.

How that?

For your limited sample, try

Code:

awk '
FNR == NR       {sub (/\./, "/", $1)
                 T[$1] = $2
                 next
                }
                {for (t in T) if ($0 ~ t) TF = t
                }
TF && /<value/  {sub (/>[^<]*</, ">" T[TF] "<")
                 TF = ""
                }
1
' FS="~" flatfile xmlfile
<name>Application/Env</name>
<value>DEV</value>
<name>Application/ID</name>
<value>99999</value>

Thank you RudiC, the replacements are working perfectly.