Shell Programming and Scripting

example of output is

[HTML]<Node>Voice
<Condition>TeleServiceCode
<Code>0</Code>
</Condition>
<Node>ShortCode1
<Node>Voice Short Code_1700
<Condition>NumberList
<Type>0</Type>
<Number>1700</Number>
</Condition>
<Tariff>Rate
<Price>13.05</Price>
<Interval>60</Interval>
</Tariff>
</Node>
<Node>Voice Short Code_1500
<Condition>NumberList
<Type>0</Type>
<Number>1500</Number>
</Condition>
<Tariff>Rate
<Price>6.97</Price>[/HTML]

where the input file is something like this

<Node>Voice
<Condition>TeleServiceCode
<Code>0</Code>
</Condition>
<Node>ShortCode1
<Node>Voice Short Code_1700
<Condition>NumberList
<Type>0</Type>
<Number>1700</Number>
</Condition>
<Tariff>Rate
<Price>12.65</Price>
<Interval>60</Interval>
</Tariff>
</Node>
<Node>Voice Short Code_1500
<Condition>NumberList
<Type>0</Type>
<Number>1500</Number>
</Condition>
<Tariff>Rate
<Price>6.325</Price>

Add 6%?

Code:

nawk -F'</*Price>' '(NF == 3 &&
  $0 = sprintf("<Price>%.2f</Price>", $2 * 1.06)) ||
    1' file > file_new

With Perl:

Code:

perl -i.bak -pe's|(<Price>)(.+?)(</Price>)|
  $1.sprintf("%.2f",$2*1.06).$3|e' file

13.05 != 12.65 * 1.06 and neither is 6.97 != 6.325*1.06 so I am not sure what the requirements are here.

Code:

cat file2
12.65 13.05
6.325 6.97

Code:

cat file1
<Node>Voice
<Condition>TeleServiceCode
<Code>0</Code>
</Condition>
<Node>ShortCode1
<Node>Voice Short Code_1700
<Condition>NumberList
<Type>0</Type>
<Number>1700</Number>
</Condition>
<Tariff>Rate
<Price>12.65</Price>
<Interval>60</Interval>
</Tariff>
</Node>
<Node>Voice Short Code_1500
<Condition>NumberList
<Type>0</Type>
<Number>1500</Number>
</Condition>
<Tariff>Rate
<Price>6.325</Price>

Code:

awk '
BEGIN {
   while ((getline < "file2") > 0)
      p[$1] = $2
} {
   FS = "</*Price>"
   if ($2 in p) {
      split($0, x, /[0-9.]+/)
      print x[1] p[$2] x[2]
   } else
      print
}' file1