Search Results

No, not really, this isn't exactly what I wanted.
There was a little mistake in the output I had shown, sorry! I've corrected it now.

I do want to compare $1 of file-1 with both columns of...

I have a file (file-1) that looks like this,
DIP-10097N|refseq:NP_416170|uniprotkb:P30015
DIP-10117N|refseq:NP_414973|uniprotkb:P08177
DIP-10168N|refseq:NP_418766|uniprotkb:P15005...

I have file that looks like this,

DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151
DIP-19241N|refseq:NP_524261 ...

Yep, it works. Thanks a lot :)

I have a file that looks like this,
P38112 Q12389; Q03532; P43586; Q08208; P37838; P40693; P38805
Q12389 P32892; P36049; Q03532; P43586; Q12176; P38112; P39744; P37838
P11154 P39940
P50094...

Thanks a lot R. Singh

I have a file that looks like this:

DIP-27772N DIP-18408N refseq:NP_523941
DIP-23436N|refseq:NP_536784 DIP-23130N|refseq:NP_652017
DIP-22958N|refseq:NP_651195 ...

Thank you Mr. Don Cragun (https://www.unix.com/members/302122727.html) for the correct answer.

Thank you RavinderSingh13 (https://www.unix.com/members/302148617.html) for the comment. Query 1 is resolved if I place the file with less lines as file1 and that with more lines as file 2. But I need...

Thank you for the script @RavinderSingh13 (https://www.unix.com/members/302148617.html).

There are two queries with the current script;
1. The output lacks the line which should contain a dash...

I have 42 text files; each containing up to 34 lines with following structure;

file1
H-01 23
H-03 5
H-05 9
H-02 14
.
.

file2
H-01 17
H-02 43
H-04 7
H-05 8
H-03 7
.
.

file3

I have a large dataset with following structure;

C 0001 Carbon [C]
D SAR001 methane [CH3]
D SAR002 ethane
D SAR003 propane
D SAR004 butane
D SAR005 pentane
C 0002 Hydrogen [H]...

Oh yes I got it. thanks.
now i can change the code into
awk '{sub(/\_$/,"anything",$2);print}to print anything I want at the end of column 2.

Thanks a lot :)

One thing more, how can I...

Thanks R. Singh but I am not really getting it, possibly because i have a very limited knowledge of awk commands.
what do I have to do if I only want to remove the _ from 2nd column? I have tried...

Hi,

I have a file like this (about 8 columns in total, this being the 2nd column)
gi_49482297_ref_YP_039521.1_
gi_49482297_ref_YP_039521.1_
gi_49482315_ref_YP_039539.1_...

Yep, that's a mistake on my part. They sure don't match exactly.
The contents of file-A and B that I have given in my question initially was just an example (and not a very good one) of a very large...

Actually both the columns of file-B are interacting-protein-partners.
I want to match the column4 of file-A with both the columns of file-B, to see which of the protein of column4, file-A is also...

Dear All,

I have two files. File-A having 5 columns and File-B having 2 columns.
I want to match 4th column of file-A with both columns of file-B and print all contents of file-A + the matching...