Homerhrdz has asked for the wisdom of the Perl Monks concerning the following question:
But i would like to use perl to sort and add the last two colums and break it out like this|M737|5555|Jun 05,2010|753|4562| |M737|5555|Jun 05,2010|123|4562| |Q569|5555|Jun 05,2010|584|4562| |Q569|5555|Jun 05,2010|345|4562| |Q569|5555|Jun 05,2010|215|4562| |Q569|5555|Jun 05,2010|845|4562| |M729|5652|Jun 11,2010|198|4562| |M729|5876|Jun 15,2010|298|4562| |M729|5726|Jun 18,2010|428|4562| |M729|5147|Jun 20,2010|918|4562| |M729|5632|Jun 01,2010|938|4562|
I would appreciate the helps thanks guys|M729|5555|Jun 05,2010|498|4562| |M729|5555|Jun 06,2010|978|4562| |M729|5632|Jun 01,2010|938|4562| |M729|5652|Jun 11,2010|198|4562| |M729|5726|Jun 18,2010|428|4562| |M729|5876|Jun 15,2010|298|4562| there were $A m729s and total of 2nd to last row was 898453 and total +of last row was 78665156 ###I just made up those total numbers |M737|5555|Jun 05,2010|123|4562| |M737|5555|Jun 05,2010|563|4562| |M737|5555|Jun 05,2010|725|4562| |M737|5555|Jun 05,2010|753|4562| |M737|5555|Jun 07,2010|913|4562| |M737|5555|Jun 08,2010|921|4562| there were $A m737s and total of 2nd to last row was 898453 and total +of last row was 78665156 ###I just made up those total numbers |Q569|5555|Jun 05,2010|215|4562| |Q569|5555|Jun 05,2010|345|4562| |Q569|5555|Jun 05,2010|457|4562| |Q569|5555|Jun 05,2010|584|4562| |Q569|5555|Jun 05,2010|785|4562| there were $A m737s and total of 2nd to last row was 898453 and total +of last row was 78665156 ###I just made up those total numbers
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Sorting and Arranging data from input file
by toolic (Bishop) on Jun 10, 2010 at 23:25 UTC | |
|
Re: Sorting and Arranging data from input file
by choroba (Cardinal) on Jun 10, 2010 at 21:47 UTC | |
by Homerhrdz (Initiate) on Jun 11, 2010 at 14:36 UTC | |
by toolic (Bishop) on Jun 12, 2010 at 21:51 UTC |