topic find and replace string in xml files in Operating System - HP-UX

find and replace string in xml files

diwakar_4 — Thu, 14 Aug 2008 09:50:30 GMT

Hi All,

I have 5 xml contains string:

040164.40
020383.20

Values of tags may differ in files. I want the output
like (after desimal only 2 zeros)
401644.00
203832.00

We need program or command that will go each file find these tags(Easting and Northing and update the entry).

Can some one help me in this regard?

Thanks..

Re: find and replace string in xml files

TTr — Thu, 14 Aug 2008 10:51:28 GMT

This might do it

sed '/.*<\/Easting>/s/\.../\.00/g' filename > filename.new

repeat by replacing "East" with "North" and keeping track of the intermediate files. If you have more lines that start and end the same way but don't have numbers in them you need to narrow down the search string to numbers only.

Re: find and replace string in xml files

Dennis Handly — Fri, 15 Aug 2008 06:29:57 GMT

If you only want to change the lines with Easting and Northing, you can do:
sed -e 's:$.*\.$..:\100\2:' \
-e 's:$.*\.$..:\100\2:' filename

If you want to change all numbers to have .00, that's easier.

Re: find and replace string in xml files

diwakar_4 — Mon, 18 Aug 2008 04:59:18 GMT

Hi Dennis and Ttr,
Many thanks,

It is looks quite ok but what it is doing is :

040164.40 changing to

040164.00 i want out put like
0401644.00. Could you please suggest on this.

Thanks

Re: find and replace string in xml files

Dennis Handly — Mon, 18 Aug 2008 12:18:27 GMT

>but what it is doing is

Oops, I didn't notice you multiplied by 10.

sed -e 's:$.*\.\(.$0:\1\2.00\3:' \
-e 's:$.*\.\(.$0:\1\2.00\3:' filename

Re: find and replace string in xml files

Rasheed Tamton — Mon, 18 Aug 2008 12:37:38 GMT

Hi Diwakar,

It is a kind of "patch work". But this is what comes to my mind now - and it works. Try with different source files to make sure the result is correct:

cat filename
040167.40
090968.70
00240164.90
0920383.80
0170381.20

sed 's/\.//g' filename|awk -F"0

0401674.00
0909687.00
002401649.00
09203838.00
01703812.00

Regards.

Re: find and replace string in xml files

Dennis Handly — Mon, 18 Aug 2008 23:25:32 GMT

Oops, a slight typo, a missing \):
sed -e 's:$.*$\.$.$0:\1\2.00\3:' \
-e 's:$.*$\.$.$0:\1\2.00\3:'

Re: find and replace string in xml files

diwakar_4 — Tue, 19 Aug 2008 06:20:02 GMT

Hi All,

Thanks a lot it works for me. But i struck in one place where i want to regular expression with if condition like

var=13
if [ $var [1-9]0 ] ; then

echo " required no contains first digit between 1-9 and followed by 0 "

else

echo " num does not follow patterns "

fi;

Please suggest correct way to right this.

Thanks a lot

Re: find and replace string in xml files

Dennis Handly — Tue, 19 Aug 2008 07:18:13 GMT

>But I struck in one place where I want to regular expression with if condition like

To handle file matching patterns you can do:
for var in 13 20; do
if [[ "$var" = [1-9]0 ]]; then
echo "$var: matches pattern"
else
echo "$var: doesn't match"
fi
done

Re: find and replace string in xml files

diwakar_4 — Tue, 19 Aug 2008 07:23:40 GMT

Hi Dennis,

Thanks a ton,

It is working.

Thanks