Compare & replace contents within a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare & replace contents within a file
# 1  
Old 05-24-2008
Compare & replace contents within a file

I have 2 files

file1
Code:
1       TMQUEUE QUE1    STMW633A
100     DMADM   DOMGRPSTMW633A  STMW633A
100     GWADM   GWTGRPSTMW633A  STMW633A
100     GWADM   GWTGRPSTMW633AA STMW633A
100     GWADM   GWTGRPSTMW638A  STMW638A
100     TMSYSEVT        EVTGRPSTMW633A  STMW633A
100     TMSYSEVT        EVTGRPSTMW638A  STMW638A
100     WSL     WSLGRPSTMW633A  STMW633A
100     WSL     WSLGRPSTMW638A  STMW638A

file2
Code:
1 TMQUEUE QUE1 1
100 DMADM DOMGRPSTMW633A 1
100 GWADM GWTGRPSTMW633A 1
100 GWADM GWTGRPSTMW633AA 1
100 GWADM GWTGRPSTMW638A 1
100 TMSYSEVT EVTGRPSTMW633A 1
100 TMSYSEVT EVTGRPSTMW638A 1
100 WSL WSLGRPSTMW633A 1
100 WSL WSLGRPSTMW638A 1

First 3 columns in the files are same except the 4th one. I want to replace
1st column in file2 with the 4th column in file1 by comparing first 3 columns from both the files.

Thanks in advance

Last edited by Yogesh Sawant; 05-27-2008 at 08:12 AM.. Reason: added code tags
# 2  
Old 05-24-2008
Code:
awk 'NR==FNR{a[$3]=$4;next}
a[$3]{$1=a[$3];print}' file1 file2

If you get errors use nawk or /usr/xpg4/bin/awk on Solaris.

Regards
# 3  
Old 05-27-2008
Thanks. It worked.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get... (22 Replies)
Discussion started by: pottic
22 Replies

2. Shell Programming and Scripting

How to compare two file contents which created within one hour?

Hi Gurus, I need to compare two file contents and log the difference. the detail as below: in current directory there is file abc20140728_1020.txt abc20140728_1110.txt I need to find the files which created within 60 minutes first then compare the contents. I am able to use find... (12 Replies)
Discussion started by: ken6503
12 Replies

3. Shell Programming and Scripting

Compare File & Copy Replace if Successful

Hi All, I have written a shell script that creates a backup of my MySQL database. The script performs the following functions: Creates a Backup of the MySQL database Compresses the Backup Copies the Backup to a Remote Server Send an E-Mail displaying the size of the Backup Removes any... (6 Replies)
Discussion started by: SalientAnimal
6 Replies

4. Shell Programming and Scripting

Replace partial contents of file with contents read from other file

Hi, I am facing issue while reading data from a file in UNIX. my requirement is to compare two files and for the text pattern matching in the 1st file, replace the contents in second file by the contents of first file from start to the end and write the contents to thrid file. i am able to... (2 Replies)
Discussion started by: seeki
2 Replies

5. Shell Programming and Scripting

script to grep a pattern from file compare contents with another file and replace

Hi All, Need help on this I have 2 files one file file1 which has several entries as : define service{ hostgroup_name !host1,!host5,!host6,.* service_description check_nrpe } define service{ hostgroup_name !host2,!host4,!host6,.* service_description check_opt } another... (2 Replies)
Discussion started by: namitai
2 Replies

6. Shell Programming and Scripting

shell script to compare file contents

Hello Has anyone got an example shell script that I can use to compare the contents of two files. The files should contain the same contents, eg. file1.txt apple pear grape file2.txt apple pear grape (2 Replies)
Discussion started by: deedaz
2 Replies

7. UNIX for Dummies Questions & Answers

How to compare 2 files & get specific value & replace it in other file.

Hiiii Friends I have 2 files with huge data. I want to compare this 2 files & if they hav same set of vales in specific rows & columns i need to get that value from one file & replace it in other. For example: I have few set data of both files here: a.dat: PDE-W 2009 12 16 5 29 11.11 ... (10 Replies)
Discussion started by: reva
10 Replies

8. UNIX for Dummies Questions & Answers

compare 2 file contents , if same delete 2nd file contents

Give shell script....which takes two file names as input and compares the contents, is both are same delete second file's contents..... I try with "diff"...... but confusion how to use "diff" with if ---else Thanking you (5 Replies)
Discussion started by: krishnampkkm
5 Replies

9. Shell Programming and Scripting

Compare two files and remove all the contents of one file from another

Hi, I have two files, in which the second file has exactly the same contents of the first file with some additional records. Now, if I want to remove those matching lines from file2 and print only the extra contents which the first file does not have, I could use the below unsophisticated... (3 Replies)
Discussion started by: royalibrahim
3 Replies

10. UNIX for Dummies Questions & Answers

compare array contents with file

I have an array "arrA" with the following contents: A0012 Paint Shop.doc ES001 Contract Signature.doc Budget Plan.pdf TS PWS.pdf My data file "Files.dat" has the same contents: A0012 Paint Shop.doc ES001 Contract Signature.doc Budget Plan.pdf TS PWS.pdf I have a script that compares... (0 Replies)
Discussion started by: orahi001
0 Replies
Login or Register to Ask a Question