Visit Our UNIX and Linux User Community


Need Help in comparing 2 text files in shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need Help in comparing 2 text files in shell script
# 1  
Old 08-26-2013
Linux Need Help in comparing 2 text files in shell script

Hi All,

I have 2 files like below

vi f1
Code:
frog
elephant
rabit
zebra
dog

vi f2

Code:
rabit
dog

==============

Now i want to comapre two files and the result will be
Code:
frog
elephant
zebra


that means...the elements are not in f2 while compare with f1


Kindly do me helpfull

Thanks

Last edited by Scrutinizer; 08-26-2013 at 04:01 AM.. Reason: code tags
# 2  
Old 08-26-2013
You may use comm command. Look at

Code:
man comm

# 3  
Old 08-26-2013
Code:
nawk 'FNR==NR{a[$1]++;next}!a[$1]' f2 f1
use awk for linux

# 4  
Old 08-26-2013
Try:
Code:
grep -vf f2 f1

This User Gave Thanks to Scrutinizer For This Post:
# 5  
Old 08-26-2013
Thank you very much for replying me.

I have used
Code:
comm-3 f1 f2

...but i m not getting the required out put

Last edited by Scrutinizer; 08-26-2013 at 04:04 AM.. Reason: code tags
# 6  
Old 08-26-2013
comm only works on lexically sorted files.
# 7  
Old 08-26-2013
Quote:
Originally Posted by Scrutinizer
Try:
Code:
grep -vf f2 f1

my grep does not support "f" option unfortunately so i went for awk.

Code:
bash-3.00$ grep -vf f2 f1
grep: illegal option -- f
Usage: grep -hblcnsviw pattern file . . .


Previous Thread | Next Thread
Test Your Knowledge in Computers #528
Difficulty: Medium
The Extended ASCII character set adds support for 128 additional characters (numbered 128 through 255) by adding 1 more bit (16 total).
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script needed for comparing two files

Hi, I need shell script to compare the two files based on certain fields and output should contains the required fields based on result.pls find sample input files and required output file 1 COUNT, BNG_IP,PORT,OVLAN 22 , 10.238.60.129,1/1,2009 144 , 10.238.60.129,1/1,2251 ... (5 Replies)
Discussion started by: surender reddy
5 Replies

2. Shell Programming and Scripting

shell script for comparing two files

Hi, I have 2 files as below FILE1.dat co1|co2|co3 abnd|45.56|AZ dkny|30.2|PA sam|.23|VA FILE.CTL FILENAME|FILE1.dat NO OF RECORDS|3 CHECKSUM|75.99 Could you please help me to write a shell script to compare 1. TOTAL RECORDS from FILE1.dat with NO of RECORDS in FILE.CTL 2.... (8 Replies)
Discussion started by: dreamsportsteam
8 Replies

3. Shell Programming and Scripting

Comparing 2 files using shell script

Hi Experts, I have 2 files 1 file consists of 800 records and 2 file consists of 100 records with matching column as Membership_Num.So i need a script which will compare the 2 files and displays the output.As these are the files the script should take any delimter like (tab,comma) as input... (6 Replies)
Discussion started by: naveen.dasu
6 Replies

4. Shell Programming and Scripting

comparing 2 files in shell script

I have 2 files config1h.txt ----------------- BFMU=ENABLE,ID=PM THR=OFF,REP=ALL,CON=IACM,TIM=OFF;GPON collection strategy 1.3.6.1.2.1.2.2:8 1.3.6.1.2.1.2.2:7 1.3.6.1.4.1.637.61.1.35.11.4:4 1.3.6.1.4.1.637.61.1.35.11.4:3 1.3.6.1.4.1.637.61.1.35.10.1:2 1.3.6.1.4.1.637.61.1.35.10.1:43... (7 Replies)
Discussion started by: LavanyaP
7 Replies

5. Shell Programming and Scripting

comparing to text files

Hi All, I have two files of the following formats file 1 - this is a big file >AB_1 gi|229194403|ref|ZP_04321208.1| group II intron reverse transcriptase/maturase gdfjafhlkhlnlklaklskckcfhhahgfahajfkkallalfafafa >AB_2 gi|229194404|ref|ZP_04321209.1| gfksjgfkjsfjslfslfslhf >AB_3... (1 Reply)
Discussion started by: Lucky Ali
1 Replies

6. Shell Programming and Scripting

comparing two files using shell script

hi experts please help me to compare two files which are in different directory file1<file will be master file> (/home/rev/mas.txt} ex x1 x2 file2 <will be in different folder> (/home/rev/per/.....) ex x3 x4 the filesinside per folder i need to compare with master file and the files... (2 Replies)
Discussion started by: revenna
2 Replies

7. UNIX for Dummies Questions & Answers

shell script for comparing 2 files

Hi, how to read the 2 files and compare each other in shell script? i have 2 files test1 and test2, both files contains 20 character records.we have to compare file 1 records with file2, if exists then reject the record else we have to append it to test2 file. in file test1 around 100 single... (2 Replies)
Discussion started by: prashanth.spl
2 Replies

8. Shell Programming and Scripting

shell script comparing files in a file

There is a text file that contains the data in the following format: COLUMN1 COLUMN2 ABC 1 ABC 2 ABC 3 DEF 4 DEF 5 XYZ 7 We have to create a second text file... (4 Replies)
Discussion started by: raina_nalin
4 Replies

9. UNIX for Dummies Questions & Answers

comparing text files

I am comparing text files where there are number of rows of numbers from window to unix box Is there any way of checking lets say 4 document of text file and seeing the difference only (or missing rows of numbers) with simple commands with lets say a batch file FROM ABSOULTE... (2 Replies)
Discussion started by: sjumma
2 Replies

Featured Tech Videos