awk NR==FNR compare 2 files produce a 3rd

borderblaster · #1 (**permalink**) 03-16-2009

hi, i have two files, both with 3 columns, the 3rd column has common values between the two files and i want to produce a 3rd file with 4 columns.

file 1

a, ,b c

file 2

a, b ,d

I want to compare the 3rd value and if a match print to file 3 with the 3 columns from the first file plus the entitlement column from file 2 added as 4th column , delimited.

file 3

a, b, c, d

I have been trying things like this borrowed off other posts but its outputing completely wrong, ive never really used awk that much

awk 'NR==FNR{x[$3]=$2;next}$3 in x&&$2=x[$3]' OFS="," FS="," file2 file1

pmm · #2 (**permalink**) 03-16-2009

Code:

nawk -F, '
{ if ( FILENAME == "file1" )
        _[$3]=$0
        else
        _[$3]=_[$3]","$1 }
END { for ( i in _ ) print _[i] }
' file1 file2

borderblaster · #3 (**permalink**) 03-17-2009

When I run this I get a syntax error, I only have awk on the server as well

awk -F, '{ if ( FILENAME == "file1.txt" )_[$3]=$0 else _[$3]=_[$3]","$1 }END { for ( i in _ ) print _[i] }' file1.txt file2.txt
awk: cmd. line:1: { if ( FILENAME == "file.txt" )_[$3]=$0 else _[$3]=_[$3]","$1 }END { for ( i in _ ) print _[i] }
awk: cmd. line:1: ^ syntax error

Franklin52 · #4 (**permalink**) 03-17-2009

Try this:

Code:

awk -F, 'NR==FNR{a[$3]=$1;next}$3 in a {$4=a[$3]}1' OFS="," file2 file1

Use nawk or /usr/xpg4/bin/awk on Solaris if you get errors.

Regards

rikxik · #5 (**permalink**) 03-17-2009

Code:

$ cat a.txt
cust1, ac1, 100
cust2, ac2, 200
$ cat b.txt
100000, cust1, 100
2000000, cust2, 200
$ join -a 1 -a 2 -1 3 -2 3 -t"," -o 1.1 1.2 1.3 2.1 a.txt b.txt
cust1, ac1, 100,100000
cust2, ac2, 200,2000000

Mind you, both files need to be sorted on the key column (stbid). In this case a.txt and b.txt are already sorted.

borderblaster · #6 (**permalink**) 03-17-2009

franklin, ive realised i need to compare two columns, i.e. if both customer id and account id match in both files then append packageid to the end of the relevent line in the first file. Can that be done?

Franklin52 · #7 (**permalink**) 03-17-2009

Post an example of both files. You have not specify a colomn for the account id in your second file.

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to compare 2 files.	ashoka123	Shell Programming and Scripting	6	10-21-2008 02:38 AM
need to compare two files	sriu76	UNIX for Dummies Questions & Answers	1	09-25-2008 05:57 AM
compare files	danabo	Shell Programming and Scripting	3	05-19-2008 12:09 PM
compare files	spt	Shell Programming and Scripting	1	05-09-2008 10:57 AM
help! need to compare files	danielsf	Shell Programming and Scripting	6	07-09-2003 05:09 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: