adding comma seperated values from a multi line file and displaying data



I am a Perl newbie, and I inherited a Survey web page that takes in 19
questions and 1 open comment, and writes the input to a file like this:

1,0,1,0,0,0,0,1,0,0,0,1,1,1,5,5,5,5,5,Boy oh boy you guys are great!
21,1,0,1,0,0,1,0,1,0,0,1,1,1,5,4,3,2,1,You have to work on getting
people skills in order
6,0,0,0,1,1,0,0,0,0,1,1,1,1,1,2,3,4,5,keep up the good work. :)

I need to add all the numbers prior to the first comma, add them
together and display the sum. Ditto for the second column, etc.
The last 5 questions I need to count the number of 5's, 4's, 3's 2's,
and 1's from all the lines in the file, total each of those sums, and
display those numbers on a single line.
Then the comments need to be displayed in paragraphs underneath the
totals.

I also have to display a header to the top of the file:
Number CR's,OPC,Autosys,ENP,Email,Blockpoint,Catia Support,Autosys
Support,Plex 4 Support,CPM Support,No Support Required,Delivery
Time,Support Service,Process Performance,Product Eval,Delivery
Eval,Reliablility Eval,Tech Support Eval,Overall Eval,Comments

Any help would be greatly appreciated!!

.



Relevant Pages

  • RomFS: enless loop during make oldconfig from 2.6.24 -> 2.6.31-rc4 (parisc)
    ... # IPVS transport protocol load balancing support ... # DCCP Kernel Hacking ... # Device Drivers ... # Display device support ...
    (Linux-Kernel)
  • RE: subheaders with totals for each
    ... so with this how can i add totals for each subheader/group? ... on adding sum total footer in GridView or datagrid: ... How to Display Sum Total in the Footer of the GridView Control ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Save Child GridView only when parent GridView Saved
    ... the page will display multiple Questions and each of which ... I suggest you use Repeater + GridViewbecause ... Since you said that the answer list of each question support ... DataList/GridView control, we need to update the certain anwser record's ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Choose function in Excel 2003
    ... a data range for a month-to-date display. ... These would be simple to fix with a sum function, however, in the same ... here is an example of how the formula was written prior ... we are in for the month (or which day I would like to see totals through). ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Choose function in Excel 2003
    ... a data range for a month-to-date display. ... These would be simple to fix with a sum function, however, in the same sheet ... we are in for the month (or which day I would like to see totals through). ...
    (microsoft.public.excel.programming)