Hi

I have a set of input strings in a pattern as given below

string1 string2 string3 string4 string5


I need to search this sequence of strings from a file in such a way that the first two strings (string1 and string2) and last two strings (string4 and string5) should match with the strings in the SECOND column of a text file (consisting of three columns) after the comparison of the numbers from the respective column.

So, the script will perform searching for the strings which matches string1, string2, string4 and string5 from a big text file called TEXTFILE.TXT . Then, it'll return the string which has the biggest number (-ve number) in FIRST column and the string which has the biggest -ve number in the third column.


A sample file format of the TEXTFILE.txt is given below. The FIRST and SECOND columns are separated by a tab and SECOND and THIRD columns are separated by a tab and a space. The strings in the SECOND columns are separated by a space. There are multiple entries in the SECOND column which may be of single string upto five strings.

For example, my input is

Code:

string1  string2  string3 string4  string5

hai        wafam   cherol   makha   palli

Now there are four entries which matches the input in the textfile.So, the output will be the two string sets :

Code:

hai wafam cherolna makha palli
hai wafam cherolduna makha palli

File format of TEXTFILE.TXT

Code:

-1.391722       hai wafam cherolna makha palli     -0.6328273
-2.922845       hai wafam cherolduna makha palli -0.1190167
-2.915667       hai wafam cherolsina makha palli  -0.5702463
-2.927181       hai wafam paochena makha palli  -0.1963889
-2.925497       hai wafam khangnaduna   -0.6328273
-2.855543       hai wafam ngasigi 
-2.926619       hai wafam thamkharabani
-1.635051       hai wafam thamlamle    -0.4567362
-1.078001       hai wafam thamlamli    -0.8960688
-1.023442       adubu madu makhada yaakhidre haikhre -0.1234433
-1.432234       adubu madu ma yaakhidre haikhre  -0.5432345

I need help to write a script to perform above task. Thanks in advance .

Moderator's Comments:

Please use CODE tags (not HTML) tags for all sample input, output, and sample code segments.