Shell Programming and Scripting

Hello all,

I try to create a bash script but till now without any positiv results.
The script should replace different variables in a text file with the right xml values

Look at the following xml file:

file.xml

===================================
<?xml version="1.0" encoding="UTF-8"?>
<Daten>
<export_date>2008-07-15 16:29:01</export_date>
<language>english</language>
===================================

temp.txt

===================================
All dates were exported at <export_date>
The text was translated in <language>
===================================

script.sh

===================================
#!/bin/bash

IFS=$'\n'

for i in `cat file.xml | sed 's/>/ /g' | awk '{print $1}' | sed 's/</ /g' | sed 's/ //g'`
do


for j in `grep "$i" temp.txt | sed 's/.*<//g'| sed 's/>.*//g' `
do
#echo $j
for h in `cat temp.txt | sed -e "s/"$j"/$(cat file.xml | grep "$j" | sed 's/>/ /g' | sed 's/</ /g' | awk '{print $2}')/g" >> temp2 `
do
echo $h
done
done


done
==================================================


The aim should be

All dates were exported at 2008-07-15 16:29:01
The text was translated in english.

Do you know how I could work on this?

thx

Hi,

first save the desired information in two variables using process substitution:

Code:

read date lang < <(sed -n "s#.*date>\(.*\)</.*#\1#p;s#.*age>\(.*\)</lan.*#\1#p" file.xml)

Then substitute the markers in the temp file:

Code:

sed "s/<export_date>/${date}/;s/<language>/${lang}/" temp.txt

HTH Chris

Sorry,

little typo. It must be:

Code:

{read date; read lang} < <(sed -n "s#.*date>\(.*\)</.*#\1#p;s#.*age>\(.*\)</lan.*#\1#p" test)

And if that doesn't work (it did on zsh but not on bash):

Code:

set -- $(sed -n "s#.*date>\(.*\)</.*#\1#p;s#.*age>\(.*\)</lan.*#\1#p" file.xml )

sed "s/<export_date>/${1} ${2}/;s/<language>/${3}/" temp.txt

Thanks a lot.
That has been helpful to me!

My last issue is that the original xml file included 420 lines.
Therefore if I create now all the variables manual and in the future will be change one line in the xml file or temp.txt, then I'm lost.
Have you any idee how can I use a simply way?

THX

ah, i see, try:

Code:

while IFS="><" read a id val b 
do 
  sed -n "s#<${id}>#${val}#p" temp.txt
done < file.xml >> output

This will print the substitutions to a file called output.

super recognition,

but if the temp.txt include some others line without variables "exp. just a text line" will be not forwarded to the output. Or some variables in xml file is empty will be also dropped.