Hello

I have a text file that looks like this: 
Nancy   Location1      600.00      New service  Single
Stella   Location2     1000.00  Replacement Single
Julie      Location3        400.00  Replacement Three
Debbie    Location4    800.00   New service Three
<code>                           

I need a perl script that generates a simple report like this, all the
+ columns properly aligned:
<code>

           #Daily meter works Report#          Current date
           #Some text#

Name of consumer  Subdivision  Amount   Type of work Phase

Nancy             Location1    600.00   New service  Single
Stella            Location2    1000.00  Replacement  Single
Julie             Location3    400.00   Replacement  Three
Debbie            Location4    800.00   New service  Three

Total  2800


Signature

[download]
any quick code snippet anyone?

Any help will be appreciated.

In reply to Text file processing question by perl_seeker

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.