Diff 3 files, but diff only their 2nd column Post: 302938154

Sponsored Content

Top Forums Shell Programming and Scripting Diff 3 files, but diff only their 2nd column Post 302938154 by RudiC on Thursday 12th of March 2015 02:39:55 PM

03-12-2015

Registered User

As much as I'd like to help, I can't, same as I couldn't with your last, almost identical request. How should lines be compared? Based on line No.? On item (city? phone?)? What should the output look like? What if file2's entry is identical to file1's but different to file3's?
Please be way more specific!
What have you tried so far?

---------- Post updated at 19:39 ---------- Previous update was at 19:23 ----------

Not sure if this will meet your desired result:

Code:

awk     '               {n=split ($1, T, " "); sub (T[1] " ", "", $1)}
         FNR==NR        {C[$1]=$0; next}
         $1 in C        {X=C[$1]; m=split (X, TMP); if (TMP[m] != $2) C[$1]= X ":" $2}
         END            {for (c in C) print C[c]}
        ' FS=":" OFS=":" file2 file1 file3
Email: dns-admin@google.com
Street: 1600 Amphitheatre Parkway: Please contact contact-admin@google.com, 1600 Amphitheatre Parkway: 2400 E. Bayshore Pkwy
Admin ID:
Postal Code: 94043
City: Mountain View
Country: US
Name: DNS Admin: Dns Admin: DNS Admin
State/Province: CA
Organization: Google Inc.
Fax: +1.6506188571: +1.6506181499
Fax Ext:
Phone: +1.6506234000: +1.6502530000: +1.6503300100
Phone Ext:

But: this is based on some assumptions and it is not too robust...

Last edited by RudiC; 03-13-2015 at 06:20 PM..

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

diff 2 files; output diff's to 3rd file

Hello, I want to compare two files. All records in file 2 that are not in file 1 should be output to file 3. For example: file 1 123 1234 123456 file 2 123 2345 23456 file 3 should have 2345 23456 I have looked at diff, bdiff, cmp, comm, diff3 without any luck!

2. Shell Programming and Scripting

Simulate SVN diff using plain diff

Hi, svn diff does not work very well with 2 local folders, so I am trying to do this diff using diff locally. since there's a bunch of meta files in an svn directory, I want to do a diff that excludes everything EXCEPT *.java files. there seems to be only an --exclude option, so I'm not sure...

3. Shell Programming and Scripting

Diff b/w 2 files

Hi Masters, I have two files named file1 and file2. Both the files contains the same contents with some difference in comments,space.But no content change. I tried to find the diff between the two files to make sure that contents are same. For that i tried diff -ibw file1 file2 But...

4. Shell Programming and Scripting

diff of files

Hi, I have 2 files.I want to check if file1 is contained in file2. A.txt: ----- AAA BBB B.txt: ------ CCC AAA BBB DDD I want to check if A.txt is contained in B.txt. Can it be done using SED ?

5. Shell Programming and Scripting

diff bw two files

Hi All, I have two files which look as below File1 serial="1" name="abc" type="employee" field="IT" serial="2" name="cde" type="intern" field="Marketing" serial="3" name="pqr" type="contractor" field="IT" serial="4" name="xyz" type="employee" field="Sales" File2 serial="1"...

6. Shell Programming and Scripting

.procmailrc and uudeview (put attachments from diff senders to diff folders)

Moderator, please, delete this topic

7. Shell Programming and Scripting

serach diff filename in diff location using shell scripting

Hi, I am new to shell scripting. please help me to find out the solution. I need a script where we need to read the text file(consists of all file names) and get the file names one by one and append the date suffix for each file name as 'yyyymmdd' . Then search each file if exists...

8. Shell Programming and Scripting

Transpose Datefield from rows to column + Print time diff

Hi Experts, Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids: Input File: 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012 12:36:26,JOB_5350 Required Output:...

9. Shell Programming and Scripting

Diff between two time in hours in last column

Dear All I want to diff between two time(FIRST 4 COLUMN) in hours in last column. Kindly help me for same. 2013-11-23 15:51:23 2013-11-23 12:20:06 BRC023 CG 2013-11-23 15:51:23 2013-11-23 12:20:08 BRC064CG 2013-11-23 15:51:23 2013-11-22 13:17:49 BLM003 NG 2013-11-23 15:51:23 2013-11-22...

LEARN ABOUT DEBIAN

mojomojo::controller::admin

MojoMojo::Controller::Admin(3pm)			User Contributed Perl Documentation			  MojoMojo::Controller::Admin(3pm)

NAME

       MojoMojo::Controller::Admin - Site Administration

DESCRIPTION

       Action to handle management of MojoMojo. Click the admin link at the bottom of the page while logged in as admin to access these functions.

METHODS

   auto
       Access control. Only administrators should access functions in this controller.

   settings ( /.admin )
       Show settings screen.

   user ( .admin/user )
       User listing with pager, for enabling/disabling users.

   role ( .admin/role )
       Role listing, creation and assignment.

   create_role ( .admin/create_role )
       Role creation page.

   edit_role ( .admin/role/ )
       Role edit page.

   handle_role_form
       Handle role form processing.  Returns true when a submitted form was actually processed.

   update_user ( *private*)
       Update user based on user listing.

   precompile_pages
       Make a formatted version of content body and store it in content.precompiled.  This makes MojoMojo go zing, when loading content for page
       requests.

       Depending on the number of pages, and versions of them, this could take some minutes.  For 2000 page versions on a 2.4 GHz desktop this
       script took about 3 minutes to run.

   delete
       Delete a page and its descendants.  This is in MojoMojo::Controller::Admin because we are restricting page deletion to admins only for the
       time being.

       TODO: this method should reside in the Model, not in a Controller (issue #87).

AUTHOR

       Marcus Ramberg <mramberg@cpan.org>

LICENSE

       This library is free software. You can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2011-09-02					  MojoMojo::Controller::Admin(3pm)