UNIX for Dummies Questions & Answers

Hi Singh,

I tried your code. It only ranks the lines start with "GALGA" in file2. Actually all lines in file2 can have the corresponding mfe value in file1. Could you also take a look again? Thank you.

Yuejian

---------- Post updated at 02:41 PM ---------- Previous update was at 02:30 PM ----------

I am sorry Akshay and Singh, I guess my expression lead you guys misunderstanding, my bad. This is what I meant: if any line in file2 partially match line in file1, list the mfe value in the parenthesis and rank it. So in most situations, the line in file2 has only one partially matched line in file1. However, some line in file2 has multiple partially matched lines in file1, I only need the exact match for mfe value under this multiple partial matching situation. Basically, I want all lines in file2 have the corresponding mfe value in file1 and rank them. Sorry to make you confused.

Yuejian

Okay try this

Code:

awk '
FNR == NR {
        key[$1]
        next
}
{      
	 $1 = $1
 
	 for(k in key)
         {
		if(match($0,k))
		{
			found = 0
			for(p=1; p<=NF; p++)
			{
				s = $p ; gsub(/\..*/,x,s)
				if(!found &&  s == k)
				{
					found = 1
				}
				if(found && $p ~ /mfe:/)
				{
					key[k]+=$(p+1)
					next
				}					
			}

		}
	 }       
}
END{
	for(k in key)print k,key[k]
}
'  FS='[ |]' f2 f1

Akshay, I tried this one. It didn't rank based on the mfe value and some lines missing mfe value. Also, in the output file, the "GALGA25_FK1" value is "-158.8" which is the sum of the partially match value.

I edited my post please try

I have looked at this thread (as you requested in PM) and I can't figure out what it is that you're trying to do. It appears that other people reading the thread are having the same problem.

You say you want an exact match, but when code is given to you that performs exact matches, you sometimes want partial matches. And if there are several partial matches we are supposed to magically guess which partial matches are supposed to be added in and which are to be ignored.

Until you can provide a clear explanation of what the code you want is supposed to do, there is little chance that you can write code that does what you want.