Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Comparing two files and inserting new fields
Top Forums Shell Programming and Scripting Comparing two files and inserting new fields Post 302472692 by Chubler_XL on Wednesday 17th of November 2010 09:06:27 PM
Old 11-17-2010
Here you go

(With Fn headings in input files and output)
Code:
awk 'NR == FNR { A[$1"|"$2]=$9; B[$1"|"$2]=$10; OFS="\t" ; next}
 FNR == 1 { printf "F1\tF2\tF3\tF4\tF5\tF6\tF7\tF8\tF9\tF10\tF11\tF12\tF13\tF14\tF15\tF16\n" }
 FNR > 1 { print A[$1"|"$2], B[$1"|"$2], $0; } ' fileB fileA

(Without Fn headings)
Code:
awk 'NR == FNR { A[$1"|"$2]=$9; B[$1"|"$2]=$10; OFS="\t" ; next}
 { print A[$1"|"$2], B[$1"|"$2], $0; } ' fileB fileA

This User Gave Thanks to Chubler_XL For This Post:
GoldenFire
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging two files by comparing three fields

Hi Experts, I need your timely help. I have a problem with merging two files. Here my situation : Here I have to compare first three fields from FILE1 with FILE2. If they are equal, I have to append the remaining values from FILE2 with FILE1 to create the output. FILE1: Class ... (3 Replies)
Discussion started by: Hunter85
3 Replies

2. Shell Programming and Scripting

Comparing two files and replacing fields

I have two files with ids and email addresses. File 2 cotains a subset of the records in file 1. The key field is the first field containing the id. file 1: 123|myadr@abc.com 456|myadr2@abc.com 789|myadr3@abc.com file 2: 456|adr456@xyz.com Where the record appears in the second... (3 Replies)
Discussion started by: tltroy
3 Replies

3. Shell Programming and Scripting

Comparing fields in two files

Hi, i want to compare two files by one field say $3 in file1 needs to compare with $2 in file2. sample file1 - reqd_charge_code 2263881188,24570896,439 2263881964,24339077,439 2263883220,22619162,228 2263884224,24631840,442 2263884246,22612161,442 sample file2 - rg_j ... (2 Replies)
Discussion started by: raghavendra.cse
2 Replies

4. Shell Programming and Scripting

Problem in comparing 2 fields from 2 files

I've 2 files. Need to compare File1.Field1,File1.Field2 with File2.Field1,File2.Field2. If matches then create a new file. File1 10 A|ADB|967143.24|1006101.5 3E HK|DHB|24294.76|242513.89 ABN ACU|ADB|22104.69|51647.14 ABN BU|DBA|39137.14|109128.38 ABN|ADB|64466.89|167936.55 ABOC... (2 Replies)
Discussion started by: buster
2 Replies

5. Programming

comparing two fields from two different files in AWK

Hi, I have two files formatted as following: File 1: (user_num_ID , realID) (the NR here is 41671) 1 cust_034_60 2 cust_80_91 3 cust_406_4 .. .. File 2: (realID , clusterNumber) (total NR here is 1000) cust_034_60 2 cust_406_4 3 .. .. (11 Replies)
Discussion started by: amarn
11 Replies

6. Shell Programming and Scripting

comparing two files for matching fields

I am newbie to unix and would please like some help to solve the task below I have two files, file_a.text and file_b.text that I want to evaluate. file_a.text 1698.74 1711.88 6576.25 899.41 3205.63 4187.98 697.35 1551.83 ... (3 Replies)
Discussion started by: gameli
3 Replies

7. Shell Programming and Scripting

Comparing two files using four fields

I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5). Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2 are... (1 Reply)
Discussion started by: NamS
1 Replies

8. Shell Programming and Scripting

Comparing two files using four fields

Dear All, I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5). Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2... (6 Replies)
Discussion started by: NamS
6 Replies

9. UNIX for Advanced & Expert Users

Need urgent help in comparing two fields in two files

Hi all, I have two files as below. I need to compare field 2 of file 1 against field 1 of file 2 and field 5 of file 1 against filed 2 of file 2. If both matches , then create a result file 1 with first file data and if not matches , then create file with first fie data. Please help me in... (1 Reply)
Discussion started by: sivarajb
1 Replies

10. Shell Programming and Scripting

Comparing two files by two matching fields

Long time listener first time poster. Hope someone can advise. I have two files, 1000+ lines in each, two fields in each file. After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those... (6 Replies)
Discussion started by: bstaff
6 Replies

LEARN ABOUT OSF1

from

from(1) 						      General Commands Manual							   from(1)

NAME

       from - Shows whom mail messages are from

SYNOPSIS

       from [-s sender] [user]

       The from command prints out the mail header lines in your mailbox file.

OPTIONS

       Prints headers for mail sent by sender.	Specifies a mail spool directory.

	      Use this flag if you want to examine a mailbox in a directory other than /usr/spool/mail, which is the system default.

DESCRIPTION

       If user is specified, then user's mailbox is examined instead of your own.

EXAMPLES

       To display the message headings in your mailbox, enter: from

	      The  names  of  the  senders and the message dates are displayed.  To display the message headings for mail sent by a specific user,
	      enter: from -s dale

	      Displays only the message headings of the messages sent from user dale.  To display the message headings in a specific user's  mail-
	      box, enter: from dawn

	      The message headings from user dawn's mailbox are displayed, provided you have read permission for dawn's mailbox.

FILES

       User mailbox files.

SEE ALSO

       Commands:  biff(1), mail(1), mailx(1)

																	   from(1)
All times are GMT -4. The time now is 06:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy