Compare two files (Many to one comparison) Post: 302760273

Sponsored Content

Top Forums Shell Programming and Scripting Compare two files (Many to one comparison) Post 302760273 by spacebar on Wednesday 23rd of January 2013 05:38:02 PM

01-23-2013

Registered User

Not sure if I understand what your input files to 'join' are, But if they are like the below try the supplied code:
Files:

Code:

Input file1: cell
Function=1 spare i[10] = 0 0 0 0 0 0 0 0 0 0
Function=1 spareA i[10] = 0 0 0 0 0 0 0 0 0 0
Function=1 spareB i[10] = 0 0 0 0 0 0 0 0 0 0
Function=1 spareC i[10] = 0 0 0 0 0 0 0 0 0 0
Details=1 Time 65
Risk=1 Offset 80
Activ A_w_S Data No 524288 16 0 ( 0, 22) (Lm)
Activ A_w_S SC_0_1 No 40000 10 0 ( 0, 22) (Scc)
Activ A_w_S - - - - - ( 0, 7) (LmSabp)
Activ A_w_S sap No 524288 12 0 ( 0, 7) (LmRn)

Input file2: res
john Function=1 spare i[10] = 0 0 0 0 0 0 0 0 0 0
john Function=1 spareA i[10] = 0 0 0 0 0 0 0 0 0 0
john Function=1 spareB i[10] = 0 0 0 0 0 0 0 0 0 0
john Function=1 spareC i[10] = 0 0 0 0 0 0 0 0 0 0
raj Function=1 spare i[10] = 0 0 0 0 0 0 0 0 0 0
raj Function=1 spareA i[10] = 0 0 0 0 0 0 0 0 0 0
raj Function=1 spareB i[10] = 0 0 0 0 0 0 0 0 0 0
raj Function=1 spareC i[10] = 0 0 0 0 0 0 0 0 0 0
john Details=1 Time 65
raj Details=1 Time 65
john Risk=1 Offset 80
raj Risk=1 Offset 80
john 53 Activ A_w_S Data No 524288 16 0 ( 0, 22) (Lm)
john 46 Activ A_w_S SC_0_1 No 40000 10 0 ( 0, 22) (Scc)
john 55 Activ A_w_S - - - - - ( 0, 7) (LmSabp)
john 54 Activ A_w_S sap No 524288 12 0 ( 0, 7) (LmRn)
raj 53 Activ A_w_S Data No 524288 16 0 ( 0, 22) (Lm)
raj 46 Activ A_w_S SC_0_1 No 40000 10 0 ( 0, 22) (Scc)
raj 55 Activ A_w_S - - - - - ( 0, 7) (LmSabp)
raj 54 Activ A_w_S sap No 524288 12 0 ( 0, 7) (LmRn)

Code:

a=0
while [ $a -lt 30 ]
do
  sdiff ref $bsc > res
  join -a 2 -a 1 -1 1 -2 2 -o 2.1,2.2,1.1,2.3 cell res > resjoin
  ./diff                                           
  a=`expr $a + 1`
done

Just remember 'join' will only join on one field so if you want to join on multiple fields you will need to concatenate the fields for input into join.

spacebar

View Public Profile for spacebar

Find all posts by spacebar

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of two files in awk

Hi, I have two files file1 and file2 delimited by semicolon, And I want to compare column 2 and column3 of file1 to column3 and column 4 in file2. file1 -------- abc;cef;155.67;143_34; def;fgh;146.55;123.3; frg;hff;134.67;; yyy;fgh;134.78;35_45; file 2 --------- abc;cef;155.09;;...

2. UNIX for Dummies Questions & Answers

Comparison of 2 files in UNIX

Hi, There are two files in UNIX system with some lines are exactly the same, some lines are not. I want to compare these two files.The 2 files (both the files have data in Column format )should be compared row wise and any difference in data for a particular row should lead to storage of data of...

3. Shell Programming and Scripting

comparison of 2 files

Kindly help on follows. I have 2 files. One file contains only one column of mobile numbers. And total records in a file 12 million. Second file contains 2 columns mobile numbers and balance. and total records 30 million. I want to find out balance of each data in file 1 corresponding to file 2....

4. UNIX for Dummies Questions & Answers

Comparison between binary files

Hello, I would like to know if we can compare binary(non text) files in unix eg. exes Thanks Saurabh

5. Shell Programming and Scripting

Comparison of two files (sh)

Hi, I have a problem with comparison of two files file1 20100101 20090101 20080101 20071001 20121229 file2 19990112 12 456 7 20011131 19 20100101 2 567 1 987 17890709 123 555 and, sh script needs to compare of these two files and give out to me result: 20100101 2 567 1 987 it...

6. Shell Programming and Scripting

Require compare command to compare 4 files

I have four files, I need to compare these files together. As such i know "sdiff and comm" commands but these commands compare 2 files together. If I use sdiff command then i have to compare each file with other which will increase the codes. Please suggest if you know some commands whcih can...

7. Shell Programming and Scripting

Comparison of fields in Files

Hello, I have two files with tab delimited data. The file will contain details something like below: FILENAME.A.B.C. 3 5 VALID PROCESSED I would have a bench mark file. I would be getting new files of the same format. My requirement is to compare a particular field for a...

8. Shell Programming and Scripting

Comparison of multiple files

Need a write script in bournce shell. Compare all the file contents and need to generate a report. Example : Having 10 trace.log files like below trace1.log, trace2.log .... trace10.log Need to compare all the 10 files contents and provide the report as below, Assume trace...

9. Shell Programming and Scripting

Comparison of two files

Hi all I have two files which I have to compare that whetehr there is soemthing common or not body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; } body, div, table, thead, tbody, tfoot,...

10. Shell Programming and Scripting

Comparison of files

I have the requirement I have two files cat fileA something anythg nothing everythg cat fileB everythg anythg Now i shld use fileB and compare every line at fileA and get the output as something nothing

LEARN ABOUT DEBIAN

unafs

UNAFS(8)						      System Manager's Manual							  UNAFS(8)

NAME

       unafs - script to warn users about their weak passwords

SYNOPSIS

       unafs password-files cell-name

DESCRIPTION

       This  manual  page  documents  briefly  the  unafs command, which is part of the john package.  This manual page was written for the Debian
       GNU/Linux distribution because the original program does not have a manual page.  john, better known as John the Ripper, is a tool to  find
       weak passwords of users in a server.
       The unafs tool gets password hashes out of the binary AFS database, and produces a file usable by John.

SEE ALSO

       john(8), mailer(8), unique(8), unshadow(8).

       The programs are documented fully by John's documentation, which should be available in /usr/share/doc/john or other location, depending on
       your system.

AUTHOR

       This manual page was written by Jordi Mallach <jordi@debian.org>, for the Debian GNU/Linux system (but may be used by others).
       John the Ripper and mailer were written by Solar Designer <solar@openwall.com>. The complete list of contributors can be found in the CRED-
       ITS file in the documentation directory.

john								   June 03, 2004							  UNAFS(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of two files in awk

Discussion started by: jerome Sukumar

2. UNIX for Dummies Questions & Answers

Comparison of 2 files in UNIX

Discussion started by: Dana Evans

3. Shell Programming and Scripting

comparison of 2 files

Discussion started by: kamal_418

4. UNIX for Dummies Questions & Answers

Comparison between binary files

Discussion started by: smehra_20