NEED HELP

06-15-2010

Registered User

4, 0

Join Date: Jun 2010

Last Activity: 17 June 2010, 3:22 PM EDT

Posts: 4

Thanks Given: 0

Thanked 0 Times in 0 Posts

NEED HELP

Hi,
I have a folder which contains multiple config.xml files and one input file, Please see the below format.

Config Files format looks like :-

Code:

<application  name="SAMPLE-ARCHIVE">
      <NVPairs name="Global Variables">
        <NameValuePair>
            <name>MIG_Host</name>
            <value>217.171.101.225</value>
        </NameValuePair>
        <NameValuePairInteger>
            <name>MIG_Port</name>
            <value>8280</value>
        </NameValuePairInteger>       
  <services>
        <bw name="SAMPLE-ARCHIVE.par">
            <enabled>true</enabled>
            <bindings>
                <binding name="">
                    <machine>HOSTNAME</machine>
                    <product>
                        <type>bwengine</type>
                        <version></version>
                        <location></location>
                    </product>
                    <description></description>
                    <contact></contact>
               </binding>
            </bindings>
</services> 
</application>

INPUT FILE :-

Code:

MIG_Host,100.100.100.100
MIG_PORT,8080

Requirement :-

I need a shell script which should read the input file by each line and search for the first value in xml file and replace the value.

ex :-
search for "MIG_Host" in all xml files with in that folder and replace "217.171.101.225" value with "100.100.100.100"

In this way i need to apply each line to all xml files.

Thanks,
Suresh

Last edited by Scott; 06-15-2010 at 02:44 PM.. Reason: Removed formatting, added code tags

haiksuresh

View Public Profile for haiksuresh

Find all posts by haiksuresh

06-15-2010

Registered User

53, 10

Join Date: Jul 2008

Last Activity: 6 November 2018, 9:47 AM EST

Location: Dallas, TX

Posts: 53

Thanks Given: 20

Thanked 10 Times in 8 Posts

Try this

Code:

TEMP_VAR=`find . -type f -iname "*xml*"`

echo $TEMP_VAR | while read X
do
    cat $X | grep "MIG_Host"
    
    if [[ $? -eq 0 ]];
    then
        cat $X | sed "s/217.171.101.225/100.100.100.100/g" > temp_file
        chmod 777 $X
        cat temp_file > $X
        rm -f temp_file
    fi
done

aster007

View Public Profile for aster007

Find all posts by aster007

06-15-2010

Registered User

602, 83

Join Date: Sep 2007

Last Activity: 17 February 2012, 6:42 AM EST

Location: /home/sea

Posts: 602

Thanks Given: 40

Thanked 83 Times in 81 Posts

Maybe this?

Code:

$ perl -pi.bak -e 'if ($a == 1) { $_ =~ s/>.*</>100\.100\.100\.100</ ; $a=0;}
                   if ($a == 2) { $_ =~ s/>.*</>8080</ ; $a=0;}
                   $a=1 if $_ =~ /MIG_Host/;
                   $a=2 if $_ =~ /MIG_Port/;
                  ' *.xml

or

Code:

$ perl -pi.bak -e 'if ($a == 1) { $_ =~ s/>.*</>100\.100\.100\.100</ ; $a=0;} $a=1 if $_ =~ /MIG_Host/;' *.xml

if you want to change only the ip.

Last edited by pseudocoder; 06-15-2010 at 04:47 PM..

pseudocoder

View Public Profile for pseudocoder

Find all posts by pseudocoder

06-15-2010

Registered User

4, 0

Join Date: Jun 2010

Last Activity: 17 June 2010, 3:22 PM EDT

Posts: 4

Thanks Given: 0

Thanked 0 Times in 0 Posts

Quote:

Originally Posted by aster007

Try this

Code:

TEMP_VAR=`find . -type f -iname "*xml*"`

echo $TEMP_VAR | while read X
do
    cat $X | grep "MIG_Host"
    
    if [[ $? -eq 0 ]];
    then
        cat $X | sed "s/217.171.101.225/100.100.100.100/g" > temp_file
        chmod 777 $X
        cat temp_file > $X
        rm -f temp_file
    fi
done

Thats fine, But my input file may contain somany parameters all should need to be searched and replaced in all xml files. Here we have hard coded the values in the code. Please help me.

---------- Post updated at 08:45 PM ---------- Previous update was at 08:44 PM ----------

Quote:

Originally Posted by pseudocoder

Maybe this?

Code:

$ perl -pi.bak -e 'if ($a == 1) { $_ =~ s/>.*</>100\.100\.100\.100</ ; $a=0;}
                   if ($a == 2) { $_ =~ s/>.*</>8080</ ; $a=0;}
                   $a=1 if $_ =~ /MIG_Host/;
                   $a=2 if $_ =~ /MIG_Port/;
                  ' *.xml

or

Code:

$ perl -pi.bak -e 'if ($a == 1) { $_ =~ s/>.*</>100\.100\.100\.100</ ; $a=0;} $a=1 if $_ =~ /MIG_Host/;' *.xml

if you want to change only the ip.

Thats fine, But my input file may contain somany parameters all should need to be searched and replaced in all xml files. Here we have hard coded the values in the code. Please help me.

haiksuresh

View Public Profile for haiksuresh

Find all posts by haiksuresh

Shell Programming and Scripting

NEED HELP