---------- Post updated at 11:51 PM ---------- Previous update was at 11:37 PM ----------
Quote:
Originally Posted by RavinderSingh13
Hello Nebula,
Welcome to forums, hope you will enjoy learning/sharing knowledge/technology experiences here. Kindly use code tags for any Input_file/sample/codes. Could you please try following and let me know if this helps you.
Thanks,
R. Singh
Thanks RavinderSingh, it worked but gave a bit limited output let me explain what it missed adding one row in file2 in my previous example.
file 1:
file 2:
Output with your command returned the same output as described by me earlier:
But the desired output in this case should be like below:
Or if files are sorted (like in case of DRL's suggestion)than below
Please do share the updated command that will help me understanding more about NF and AWK, Thanks once again
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)
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)
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)
cat file1
1 a b c
2 d e f
3 a f r
cat file2
a c e
output should be
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. (9 Replies)
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)
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)
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)
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)
Hi everybody!
need some awk-support. i want a line-selective printout of a file.
wat i normally will do with ...
awk ' FNR==8' sample.txt
But now i need the data from line 8, 10 and the following data from line13 to 250 wich is not end of the file. I tried allready to combine it but without... (2 Replies)
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)