NR=FNR


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting NR=FNR
# 1  
Old 06-06-2012
NR=FNR

Code:
cat file1
1 a b c
2 d e f
3 a f r

Code:
cat file2
a c e

output should be
Code:
1
3

means:

if field 1 of file2 matches filed 2 of file1 then print field 1 of file1

I know that it can be done using awk NR=FNR.
But not able to acheive it.

Thanks in advance.

Last edited by Franklin52; 06-06-2012 at 08:36 AM.. Reason: Please use code tags
# 2  
Old 06-06-2012
Quote:
Originally Posted by shaan4uster
I know that it can be done using awk NR=FNR.
But not able to acheive it.
Right, what have you tried?
# 3  
Old 06-06-2012
Code:
awk 'NR=FNR {A[$1]=$1;next} {print $1}' file2 file1

IT generates
Code:
1
2
3


Moderator's Comments:
Mod Comment Please use code tags, thanks!

Last edited by zaxxon; 06-06-2012 at 08:44 AM.. Reason: code tags, see PM
# 4  
Old 06-06-2012
NR=FNR means "assign FNR to NR". A comparison would use two equal signs (==)

This doesn't help you, as the expected output from your script is
Code:
1
2
3

Code:
awk 'NR=FNR {A[$1]=$1;next} # for file2 assign $1 to A[] and print nothing and move to the next record
{print $1} # now we're in file1, print the first field (1, then 2, then 3)
' file2 file1

# 5  
Old 06-06-2012
Need Help

Yet not able to achieve it.Plz help me.
# 6  
Old 06-06-2012
Like said in the above post, use ==, not =, as = is wrong.

"not working" by itself is about the least helpful thing you can say. Please explain, in detail, how it is "not working".
# 7  
Old 06-06-2012
Here is what I see with that same code, maybe that will help you understand what he means by "not working".

Code:
$ cat file1 
1 a b c
2 d e f
3 a f r

$ cat file2 
a c e

# file1 first and file2 second, 1 = sign (assignment)
[user@host ~]$ awk 'NR=FNR {A[$1]=$1;next} {print $1}' file1 file2


# file1 first and file2 second, 2 = sign (comparison
[user@host ~]$ awk 'NR==FNR {A[$1]=$1;next} {print $1}' file1 file2
a
 
 # file2 first and file1 second, 1 = sign (assignment)
[user@host ~]$ awk 'NR=FNR {A[$1]=$1;next} {print $1}' file2 file1 

# file2 first and file1 second, 2 = sign (comparison) 
[user@host ~]$ awk 'NR==FNR {A[$1]=$1;next} {print $1}' file2 file1
1
2
3

None seem to give output expected:

Code:
1
3

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Using NR==FNR Command

Dear All, I have below two files with me: file 1: A|B E|F C|D file 2: A|X|Y R|T|I C|V|N I want to compare 1st column of each file and than print both columns of file 1 and column 2 and 3 of file 2 Sample required output in regards to above files is below: A|B|X|Y C|D|V|N (5 Replies)
Discussion started by: Nebula
5 Replies

2. Shell Programming and Scripting

Explanation of FNR in this awk script

To merge mutiple *.tab files as: file1.tab rs1 A A rs2 A A rs3 C C rs4 C Cfile2.ind rs1 T T rs2 T T rs3 G G rs4 G Gand file3.tab rs1 B B rs2 B B rs3 L L rs4 L LOutput: file1.tab file2.tab file3.tab AA TT BB AA TT BB CC GG LL CC GG ... (4 Replies)
Discussion started by: yifangt
4 Replies

3. Shell Programming and Scripting

Help with Alternative for NR==FNR

Hi, I have an issue with the below script nawk 'NR==FNR{a=$4" "$5}NR>FNR{print NF?$0:a"\n";if(/^cn:/) x=$0}' FS="" in1.txt in2.txt > out1.txt It is taking too long to get a string from in1.text, search for the string in in2.txt and create a new file out1.txt. Is there any alternative way we... (1 Reply)
Discussion started by: Samingla
1 Replies

4. Shell Programming and Scripting

Tip: alternative for NR==FNR in awk

Example: $ cat file1 2 3$ cat file2 1 2 3 4 5 6The following awk script works like a charm, NR==FNR is true for file1, the remainder runs for file2: awk ' NR==FNR {A; next} ($1 in A) ' file1 file2 2 3Now have an empty file1: >file1and run the awk script again. The result is empty... (8 Replies)
Discussion started by: MadeInGermany
8 Replies

5. Shell Programming and Scripting

How to use NA and FNR?

Hi i have file1: conn=232257 client=16218.19488.218.86:51237 protocol=LDAP file2: conn=232257 dn="uid=apple,ou=xxxx,ou=usfgfhfers,dc=example,dc=com" conn=232370 dn="uid=ball,ou=yyyyyy,ou=usfhfhfhers,dc=example,dc=com" In the output file it should match first column from above both files... (2 Replies)
Discussion started by: buzzme
2 Replies

6. Shell Programming and Scripting

NR==FNR confusions

This has been asked and answered hundreds of times, but I can't understand the syntax of awk's NR==FNR trick for merging files and printing the correct columns. Here's my File 1 1 rs8179466 224176 A ADD 1037 1.066 0.1421 0.8065 1.408 0.4468 ... (3 Replies)
Discussion started by: roofus
3 Replies

7. Shell Programming and Scripting

Awk FNR==NR question

awk -F'' 'FNR==NR {a=$2; next} {$1=a} 1' $useralias ${entries} >> ${entries}_2 Hi, Is there anyway to alter this command so that if it does not find a match it will just leave the line alone instead of replacing what it doesn't find with a blank space? (4 Replies)
Discussion started by: Jazmania
4 Replies

8. UNIX for Dummies Questions & Answers

awk NR==FNR output control

Hi Guys, I have two files: f1: A B C D E F G H f2: A X Y Z f1 has 48000 lines, and f2 has 68. I have been matching f1 $3 to f2 $1, and getting f3: A A B C D E F G I would like f3 too look like this: A X Y Z A B C D E F G (2 Replies)
Discussion started by: heecha
2 Replies

9. Shell Programming and Scripting

NR==FNR for getting Col4 value from 2nd file

Multiple versions of this are probably in this section, but could not find one just right for me. My code gives me a zero byte file. Problem: foo 553 403 448 492 451 403 456 560 527 534 529 550 500 447 404 (6 Replies)
Discussion started by: genehunter
6 Replies

10. Shell Programming and Scripting

Awk: different between NR and FNR

As I know: FNR: The ordinal number of the current record in the current file. NR: The ordinal number of the current record from the start of input. I don't understand really differency between NR and FNR. Who can explain it for me? And give me an example. Thanks (1 Reply)
Discussion started by: anhtt
1 Replies
Login or Register to Ask a Question