I am able to modify files (one file) but I have a hard time working with multiple files simultaneously.
So I have two files. Basically I want to match two files based on certain columns. Both files are tab-seperated.
File1 looks something like this:
File 2 is a much larger file and looks somethign liek this:
So what I want to do is match column 1 from Files1 and 2. I also want to substract column 2 from both files. So if they are a match, I want to print (into a seperate file) the row with the smallest difference for column 2.
So for my example above, the output file would look like this
num1 5 george bear
num4 1 bob mouse
thanks
Last edited by Yogesh Sawant; 07-05-2009 at 11:29 AM..
Reason: added code tags
Hi, How can I match the first two fields of file2 against the first two fields of file1 and where they match combine the two lines. If the name
(example-Aidan Rielly) is in file1 but not in file2 then just write the info from file1 to the combined output file. If the name
(example-Silvia... (5 Replies)
Hi
I need to check list of files aganinst a.txt and return those files which are not available in a.txt
ls -lrt
file1.txt
file2.txt
file3.txt
a.txt
=====
file1.txt
file2.txt
Expecting o/p
file3.txt (3 Replies)
Hi
I am able to match two files (fileA and B) based on the first column using this line.
awk -F"/t" 'NR == FNR { A = $0; next } A { print $0 FS A }'
However I now need to match the two files (files A and B) based on two columns. On top of that, for those that dont match, I want it to... (1 Reply)
Hello,
I have several files in a specific directory.
A specific string in one file can occur in another files.
If this string is in other files. Then all the files in which this string occured should be deleted and only 1 file should remain with the string.
Example.
file1
ShortName "Blue... (2 Replies)
I'm newbie with AWK. What I'm trying to do is matching file1 and file2 into a file3 with records listed in columns with pipe as delimiter.
The thing is the file1 has thousands of records while file2 has very few. But I want the file3 to show all records in file1 and with data from file2 to be... (2 Replies)
Hi to all,
I have two separated files:
FILE1
"V1" "V2" "V3"
Mary James Nicole
Robert Francisco Sophie
Nancy Antony Matt
Josephine Louise Rose
Mark Simon
Charles
FILE2
"V1" "V2" "V3"... (2 Replies)
Hello,
I need to match one file with another.
The best would be to give an example.
File 1
A 1
B 2
C 3
D 4
E 5
F 6
File 2
A 5 6 2
B 3 2 1
F 4 2 9 (1 Reply)
I have a file like this
AFF3 BCL2
AGTRAP BRAF
AHRR NCOA2
AKAP9 BRAF
And second input file like this
chromosome start end gene
chr1 38177326 38664955 AFF3
chr4 148077060 148088064 AGTRAP
chr13 74211117 74292309 AHRR
chr5 3928185 ... (4 Replies)
he following are the files available in my directory
RSK_123_20141113_031500.txt
RSK_123_20141113_081500.txt
RSK_126_20141113_041500.txt
RSK_126_20141113_081800.txt
RSK_128_20141113_091600.txt
Here, "RSK" is file prefix and 123 is a code name and rest is just timestamp of the file when its... (7 Replies)