I have a file with following weather related data (Max/Min temp for 7 days of week) 
Ca,Freemont 87 45 91 56 89 54 67 45 76 43 81 48 76 43
Ca,Berkley 56 34 67 38 66 34 56 31 67 45 71 45 65 42
Tx,Houston 88 34 77 36 75 31 72 30 81 31 79 51 75 28
Tx,Dallas 76 43 79 45 87 28 86 32 84 45 78 46 83 23

[download]
How can i sort and print Max and min temp for the state(not city)

my output should look like : 

Ca max temp 91 Freemont
   min temp 31 Berkley

Tx max temp 88 Houston
   min temp 28 Houston
               Dallas

[download]

In reply to How do i sort by pradsham

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.