Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Compare content between two files

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare content between two files
# 1  
Old 12-14-2012
Lightbulb Compare content between two files
I have two files in unix environment with similer type of contain:

Example:
File1 File2
Code:
Milestone1                              Milestone1
Milestone2                              Milestone12
Milestone3                              Milestone13
Milestone4                              Milestone14
Milestone5                              Milestone5
Milestone6                              Milestone16

I need to compare these two files (File1 and File2), and create output to a different file (say File3) informing

There are 2 name matching.
Names are:
Code:
Milestone1
Milestone5

Please help me with resolution. I need unix script to complete the job. I am stuck in between it for a long timeSmilie
# 2  
Old 12-14-2012
Hi, try:
Code:
grep -xFf file1 file2

This User Gave Thanks to Scrutinizer For This Post:
Mrinal Mondal
# 3  
Old 12-14-2012
Hi Scrutinizer, thanks , but it does not give me an output to a new file informing how many matching records and what are the matching data. I am working with huge number of data (nearly 900000 lines of data), it required to fetch out the numbers and the data which is matching in two files. Smilie
# 4  
Old 12-14-2012
You would need to redirect the output:
Code:
grep -xFf file1 file2 > file3

An alternative would be:
Code:
awk 'NR==FNR{A[$1]; next}$1 in A' file1 file2 > file3

This User Gave Thanks to Scrutinizer For This Post:
Mrinal Mondal
# 5  
Old 12-14-2012
Thanks
I have run the code, It does not give me any error message and successfully executed and new file created, but it does not fetch any data. Smilie

i run both the codes. Sorry I am really novice in this area and keep asking "may be very basic" questions and tricks.
Last edited by Mrinal Mondal; 12-14-2012 at 02:43 PM..
# 6  
Old 12-14-2012
Could you post an anonimized representative sample of both files?
# 7  
Old 12-14-2012
Sure. I have posted on my query details.

Suppose I have two files File1: it contain some name like Milestone1, Milestone2, Milestone3, Milestone4, Milestone5, Milestone6. File2: it contain some files like Milestone12, Milestone13, Milestone14, Milestone5, Milestone16.

I need to get output to another file as:

There are 2 file matching and these files are:
Milestone1
Milestone5
Last edited by Mrinal Mondal; 12-14-2012 at 03:30 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with compare 2 column content and corrected/replaced word

Input File CGGCGCCTCGCNNNCGAGCG CGGCGCGCCGAATCCGTGCG TCGCNGC GCGCCGC ACGGCNNNNN ACGGCCTCGCG CGGCNGCCCGCCC CGGCGCGCCGTCC Desired Output File CGGCGCCTCGCNNNCGAGCG CGGCGCGCCGAATCCGTGCG CGGCGCCTCGCATCCGAGCG TCGCNGC GCGCCGC TCGCCGC ACGGCNNNNN ACGGCCTCGCG ACGGCTCGCG... (6 Replies)
Discussion started by: perl_beginner
6 Replies

2. Shell Programming and Scripting

Compare two folders and file content

Hi, I am having two folders where i need to compare the content of files and also to know if any new files been added and redirect the difference output in respective filename logs. For e.g.: Directory D1: f1 f2 f3 Directory D2: f1 f2 f3 f4 i Need to compare the directories... (25 Replies)
Discussion started by: rohit_shinez
25 Replies

3. Shell Programming and Scripting

Ksh: how compare content of a file with an other array

Hi, I created a skript in ksh which generate a file with semicolon as separator, this is an example of the file a created: example content file: hello;AAAA;2014-08-17 hello;BBBB;2014-08-17 hello;CCCC;2014-08-17 I would need to compare the content in of the second column of this file... (3 Replies)
Discussion started by: jmartin
3 Replies

4. Shell Programming and Scripting

To compare the content of two text files

I have two files, sec.txt(1st File) 3172 disp.txt(2nd file) the file name is *********** 45676 Now i want to compare the value in sec.txt file with disp.txt file Excatly i want to compare the value 3172 in first file and 45676 in second file. i want to compare the first line of... (11 Replies)
Discussion started by: rammm
11 Replies

5. Shell Programming and Scripting

compare 2 files and show count same content.

$ cat File1 Non HTTP response code:java.net.ConnectException225073X 000000005143329Load time: 402335410224 Non HTTP response code: ava.net.ConnectException206423X 000000005143330Load time: 402305687161 Non HTTP response code: ava.net.ConnectException290212X 000000005143331Load time:... (1 Reply)
Discussion started by: ooilinlove
1 Replies

6. Shell Programming and Scripting

Compare a content of variable to a database column

Hi have an array like this colarray="a" colarray="b" colarray="c" colarray="d" colarray="e" colarray="f" the arrayvariable is in unix sh file i want to check the content of the array to oracle database table. that is whether "a" is present in the table. (4 Replies)
Discussion started by: barani75
4 Replies

7. Shell Programming and Scripting

Help with Compare and search content in directory

Hello, How to search in directory by comparing some string with the content of directory. Ex: I want to compare abhi string with the content of backup directory. i.e want to check that is there any file in backup directory having name ... (3 Replies)
Discussion started by: AbhijitIT
3 Replies

8. Shell Programming and Scripting

compare logfile content

Hi folks I have some logfiles like this: ./2009_08_22_14_08_entire_backup_no_1.log . . . ./2009_08_22_14_34_entire_backup_no_14.log each one contains a timestamp from "date +'%s'" now i need function which finds the logfile with the greatest number in it and returns (echos) the... (7 Replies)
Discussion started by: latenite
7 Replies

9. UNIX for Dummies Questions & Answers

Compare the content of a variable with a string

Hello all: I'm new in Unix and here and I'am spanish so my english isn't so good to explain my doubt. Here it is. Very urgent: I need to compare the value of a variable with a string. Example is this. Imagine that the variable x1 contains the path and a file text and I need to compare... (2 Replies)
Discussion started by: robdai
2 Replies

10. Shell Programming and Scripting

Compare the content of 2 files

Hi Guys, What is the most effecient way to compare the content of 2 seperate files and extract the result of there is a match? We have 2 separate log files and we are trying to find the common errors from the 2 files. Thanks, Odogbolu98 :( (3 Replies)
Discussion started by: odogbolu98
3 Replies
Login or Register to Ask a Question