As already stated you must show some effort, even for basic questions.

The data part (peter, john..) it is very easy (profit links given by other monks, search also chomp and split between functions )

The headers by other hand, are formatted in a very bad way, that make the appropriate parsing difficult, at least to me. To rearrange headers you need to achieve a datastructure like the following: 

[Student][]       [science][]      [total]
[]       [Roll_no][]       [Cutoff][student]
[Name]   []       [Mark]   []      [mark]

[download]
and then join all columns of the array of array, skipping undef values to have them correctly ordered.

Better if you can have headers formatted differently or even if you can hardcode them into the program.

The Perl Cookbook is aged but has tasty recipes about reading from files, if i recall correctly.

L*

There are no rules, there are no thumbs..
Reinvent the wheel, then learn The Wheel; may be one day you reinvent one of THE WHEELS.

In reply to Re: File Parsing by Discipulus
in thread File Parsing by perlmad

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.