sivaraman,
But i want the output like

Then you did a poor job of explaining your problem. I can see other potential things you haven't told us like order. Do you want the most frequent items first? Should the country codes (assuming US, GB and UK are country codes) be listed in alphabetical order on a line or should they be in the order they appeared in the file or does it matter at all?

In your first example, you had two lines that were 'abcd,US' and your desired output was '2 abcd US'. What would you have wanted if the input was 

abcd,US
abcd,US
abcd,GB

[download]

Based off your poor description so far, I would guess '3 abcd US, GB' but I wonder if it is important to know that 2 of the 3 came from US?

In general, hashes allow you to keep track of distinct items (the abcd portion) and arrays help you maintain order. When you do a better job of explaining what you want, someone will likely jump in and provide a solution but you should be able to start exploring bart's solution on your own as well.

Cheers - L~R

In reply to Re^3: Dear Monks by Limbic~Region
in thread Dear Monks by sivaraman

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.