The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. Shell Script Page.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
compare 2 files.. amon Shell Programming and Scripting 8 4 Weeks Ago 07:34 AM
compare two files charandevu Shell Programming and Scripting 7 03-30-2008 12:20 PM
Compare files kharen11 UNIX for Advanced & Expert Users 25 03-14-2007 01:35 AM
compare files and beyond MizzGail UNIX for Dummies Questions & Answers 2 04-25-2003 10:34 AM
compare files ingunix UNIX for Dummies Questions & Answers 3 05-24-2001 08:44 AM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-21-2005
Registered User
 

Join Date: Feb 2005
Posts: 48
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Compare two files

Hi,

I've got two files A and B

File A: File B:

1;2;a;4;5 1;2;1;a;4;7
3;2;b;d;s 3;3;1;b;5;1
e;2;c;s;w l;8;4;d;5;s
4;3;f;w;q p;9;r;c;4;d
e;3;q;w;q

What I need to be able to do is take column THREE from file A and compare it with column FOUR from file B.

i.e. File A (a;b;c)
File B (a;b;d;c)

The compare operation would ideally produce output like the following:

File B contains a record [d] that is not contained in File A
File A contains records [f;q] that are not contained in File B

I've used the compare command but the output is very difficult to comprehend.

Any help or pointers apperciated
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 04-21-2005
Registered User
 

Join Date: Mar 2005
Posts: 22
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
This will do,

Compare.sh
#!/bin/sh
#cut column 3 from FileA and put it to FileA.tmp
cat FileA | cut -f3 -d";" > FileA.tmp
#cut column 4 from FileB and put it to FileB.tmp
cat FileB | cut -f4 -d";" > FileB.tmp
#compare FileA.tmp and FileB.tmp
diff FileA.tmp FileB.tmp
rm FileA.tmp FileB.tmp

sh Compare.sh
2a3
> d
4,5d4
< f
< q

-Om
Reply With Quote
  #3 (permalink)  
Old 04-28-2005
Registered User
 

Join Date: Feb 2005
Posts: 48
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Exclamation Query

Could anyone please explain what the 2a3 is for below?

Is there anyway to just get the differences without the 2a3 and 4,5d4


Thanks
Reply With Quote
  #4 (permalink)  
Old 04-28-2005
vgersh99's Avatar
Moderator
 

Join Date: Feb 2005
Location: Boston, MA
Posts: 2,983
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
something to start with:
nawk -f pen.awk fileA fileB

here's pen.awk:
Code:
BEGIN {
  FS=";"
}
FNR==NR {
   arrA[$3]
   next
}
{ arrB[$4] }
END {
  printf("File B contains records [")
  for ( i in arrB )
    if ( !( i in arrA ) )
       printf("%s;", i)
  printf("] that are not contained in File A\n")

  printf("File A contains records [")
  for ( i in arrA )
    if ( !( i in arrB ) )
       printf("%s;", i)
  printf("] that are not contained in File B\n")
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes


The 50 most popular UNIX and Linux searches.
Google Search Cloud for The UNIX and Linux Forums
"inappropriate ioctl for device" 421 service not available, remote server has closed connection ^m autosys awk trim bash eval bash exec bash for loop boot: cannot open kernel/sparcv9/unix close_wait command copy/move folder in unix curses.h cut command in unix dead.letter find grep find null character in a unix file grep multiple lines grep or grep recursive grep unique inaddr_any inappropriate ioctl for device lynx javascript mailx attachment mget mtime perl array length ping port remove first character from string in k shell replace space by comma , perl script scp recursive segmentation fault(coredump) sftp batch sftp script snoop unix stale nfs file handle syn_sent tar exclude unix unix .profile unix com unix forum unix forums unix interview questions unix mtime unix simulator unix.com vi tab size vi+substitute+end+of+line+character while loop within while loop shell script


All times are GMT -7. The time now is 12:23 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101