How to sum up values

2007-04-24 Thread Andrej Kastrin
Dear all, Question about the sum function; the file structure is as follows: A|100 A|200 A|150 B|20 B|90 C|10 C|30 C|300 The result I want to obtain is to sum values in the second column (columnB) for each particular letter in the first column (ColumnA); e.g.: A|450 B|100 C|330 I don't want

RE: How to sum up values

2007-04-24 Thread Andrew Curry
beginners@perl.org Subject: How to sum up values Dear all, Question about the sum function; the file structure is as follows: A|100 A|200 A|150 B|20 B|90 C|10 C|30 C|300 The result I want to obtain is to sum values in the second column (columnB) for each particular letter in the first column (Col

Re: How to sum up values

2007-04-24 Thread Peter Scott
On Tue, 24 Apr 2007 13:33:32 +0200, Andrej Kastrin wrote: > Question about the sum function; the file structure is as follows: > > A|100 > A|200 > A|150 > B|20 > B|90 > C|10 > C|30 > C|300 > > The result I want to obtain is to sum values in the second column > (columnB) for each particular lett

Re: How to sum up values

2007-04-24 Thread Shiping Wang
Hi, At 05:33 AM 4/24/2007, Andrej Kastrin wrote: Dear all, Question about the sum function; the file structure is as follows: A|100 A|200 A|150 B|20 B|90 C|10 C|30 C|300 The result I want to obtain is to sum values in the second column (columnB) for each particular letter in the first column

Re: How to sum up values

2007-04-24 Thread Rob Dixon
Andrej Kastrin wrote: Dear all, Question about the sum function; the file structure is as follows: A|100 A|200 A|150 B|20 B|90 C|10 C|30 C|300 The result I want to obtain is to sum values in the second column (columnB) for each particular letter in the first column (ColumnA); e.g.: A|450 B|

Re: How to sum up values

2007-04-25 Thread Stanislav Nedelchev
Rob Dixon wrote: > Andrej Kastrin wrote: >> Dear all, >> >> Question about the sum function; the file structure is as follows: >> >> A|100 >> A|200 >> A|150 >> B|20 >> B|90 >> C|10 >> C|30 >> C|300 >> >> The result I want to obtain is to sum values in the second column >> (columnB) for each particu

Re: How to sum up values

2007-04-25 Thread Rob Dixon
Stanislav Nedelchev wrote: Rob Dixon wrote: Andrej Kastrin wrote: Dear all, Question about the sum function; the file structure is as follows: A|100 A|200 A|150 B|20 B|90 C|10 C|30 C|300 The result I want to obtain is to sum values in the second column (columnB) for each particular letter in