Please excuse me for my fast/paranoid decisions. i get confused easily when i face little problems. I confuse other people also... am sorry for that. I have to build some patience in me. hehehehe :) well, the criteria is to match the alphabets. The alphabets seen in the 3rd column of file2.query should be checked if its available in the 5th(last) column of file1.db. In case, the only common columns are the 2nd and 3rd of file1 and 1st and 2nd column of file2. With this as basis, i compare the alphabets in both the entries(files). For every line in file2, If all (2-seperated by'>') the alphabets (seperated by '/'. can be many, just not 2) are found in file1 at the corresponding line, its reported as a HIT. In the output i needed 
1190    31789    A > G    1    2    5    zm1829427

[download]
only in this lines, the "A>G" of file2 matches with "A/G" of file1. The rest is not considered as hit because, the alphabets of file2 in not present in file1. my final decision: the output is: 

1190    31277    A > T    1    0    0    -
1190    31607    C > A    0    3    1    -
1190    31629    C > T    0    2    0    -
1190    31789    A > G    1    2    5    zm1829427
1190    31882    A > C    0    4    0    -
1190    31883    T > A    0    4    0    -
1190    31883    T > C    2    2    5    -
1190    32199    C > T    0    1    1    -
1190    32487    T > C    0    1    1    -
1190    32496    A > G    0    3    0    -
Total number of HITS: 1

[download]

In reply to Re^4: duplicates getting omitted while comparing values inside foreach. by patric
in thread duplicates getting omitted while comparing values inside foreach. by patric

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.