I'm working with 100's of PS Account 'MONTHLY USAGE' Reports. I have been able to parse the reports, do a table lookup to match a Login ID with an Application Name. My output CSV at this point is as follows:
Login ID,Application,CPU Minutes,Percent of Total s2pe,CTI Production ,8455,21.7% sybprd01,OMS,5326,13.7% pctip01,CTI,5098,13.1% lxsadr54,CTI,1742,4.5% pipmp01,SSG-IPM,1742,4.5% maestro,SSG-RAC-Maestro ,1020,2.6% f2pa,"DB2DARI ""stored procedures"" prod",836,2.1% pomgp01,SSG-PMD-Omegamon,56,0.1% pptip01,PTI - Private Client Services,16,0.0% pbmwp01,BMW,3,0.0% s2pv,Merva,1,0.0% I am trying to accumulate the CPU Minutes and/or the Percent of Totals by Application. A real example will have multiple Login ID's per Application (the 2nd field). This example CSV has only 2 lines that can be combined (the 3rd and 4th lines with CTI). I know how to do this using SAS, but am unsure of how I might accomplish this in perl. If anyone would help me it would be greatly appreciated -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
