Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

To find Difference

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting To find Difference
# 1  
Old 02-15-2013
To find Difference
Hi Friends,

I need to find the difference between two files ,

File_1 contained 4 columns, and File_2 contained 4 columns,

I need to find the difference using 1st column,

Or need to find the difference using 3st column,
# 2  
Old 02-15-2013
For detecting differences in the first field (if this is what you mean with "column"), you could try:
Code:
paste File_1 File_2 | awk '$1 != $5'

# 3  
Old 02-15-2013
I need the count difference of the files

Which present like
File 1
Code:
1 a
2 b
3 c
4 e


File 2:
Code:
1 e
2 f
3 g


I need the row count, here compare two file 2 has -1 count.

# 4  
Old 02-15-2013
Hmm. I don't really understand what the issue is. Please wrap data and code in CODE tags.
# 5  
Old 02-15-2013
the command should Find the difference of the row or lines
# 6  
Old 02-15-2013
See the man page of the wc utility: "wc - print newline, word, and byte counts for each file"
# 7  
Old 02-16-2013
Quote:
Originally Posted by Shenbaga.d
. . .
File_1 contained 4 columns, and File_2 contained 4 columns,
I need to find the difference using 1st column,
Or need to find the difference using 3st column
Quote:
File 1
Code:
1 a
2 b
3 c
4 e
File 2:
Code:
1 e
2 f
3 g
Not sure I understand (or, better: sure I don't understand). You say in post #1, both files have 4 columns, but the files presented have two cols only.
Please be far more clear in specifying your requirements, telling us what comes from where and goes to where based on what conditions. And, be sure to tell rows from columns!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find with in loops and then difference

Hi All, Please find my problem below: I have a file at two different nodes dev and test 1st find> find /u/dev/local/abc -name ab.dat --Since this file can be in several sub directories 2nd find> find /u/test/local/abc -name ab.dat I find my 1st find result and do compare with 2nd... (5 Replies)
Discussion started by: varun_bharadwaj
5 Replies

2. UNIX for Dummies Questions & Answers

Find time difference

I have a file wich contains time formats and i need to get the time difference TIME1 TIME2 =============== =================== 20120624192555.6Z 20120624204006.5Z which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (23 Replies)
Discussion started by: wnaguib
23 Replies

3. Shell Programming and Scripting

How to find time difference?

I have a file wich contains time formats and i need to get the time difference TIME1 TIME2 ================================== 20120624192555.6Z 20120624204006.5Z which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (1 Reply)
Discussion started by: wnaguib
1 Replies

4. Shell Programming and Scripting

To find difference between two files on a whole

Hi, The requirement is to compare two files that has single column of records each. Comparison is to happen on a whole and not line by line. File1.txt 314589929 315611087 304924413 315989094 301171509 302984393 315609549 314593632 File2.txt 315611087 304924413 315989094 (2 Replies)
Discussion started by: anandek
2 Replies

5. UNIX for Dummies Questions & Answers

command difference - find

Hi, What is the difference between these two? find /some_dir -type f -exec chmod 070 {} \; and chmod 070 `find /some_dir -type f` Thanks (5 Replies)
Discussion started by: lamont
5 Replies

6. UNIX for Advanced & Expert Users

Find difference between 2 files

I have 2 files as follows. file1.txt <cell>123</cell> <cell>345</cell> file2.txt <cell>123</cell> <cell>456</cell> out out should be output.txt <cell>456></cell> How do we achieve this> The difference betwenn the two files should be wirtten to the output file.. ... (2 Replies)
Discussion started by: kanthrajgowda
2 Replies

7. UNIX for Dummies Questions & Answers

Find difference between two files

I have two files as below File1: a b c d File2: a b When i find the difference the output would be c&d.. How can i get my requirement...pls help... Many thanks in advance (10 Replies)
Discussion started by: jagadish_gaddam
10 Replies

8. Solaris

Need help to find difference between two files

I need to find the difference between two files in UNIX. I tried diff, but couldn't get it right. There are two files: file1: apple mango strawberry banana grape file2: grape apple banana I need an output file like below: ... (11 Replies)
Discussion started by: kisaad
11 Replies

9. Emergency UNIX and Linux Support

to find difference between two files

I have a file which gets appended with records daily..for eg. 1st day of the month i get 9 records ,2nd day 9 records .....till the last day in the month...the no of records may vary...i store the previous days file in a variable oldfile=PATH/previousdaysfile....i store the current days file in a... (6 Replies)
Discussion started by: ganesh_248
6 Replies

10. UNIX for Dummies Questions & Answers

Difference between locate and find

I was wondering what the difference was between the two commands, I understand that locate won't search for files with certain permissions set. Are there any others? Thanks (1 Reply)
Discussion started by: camerja1
1 Replies
Login or Register to Ask a Question