Hi All,

I'm having issues trying to manipulate the data I read from one of my logged csv files.

I have a csv file with the following information:

Date, Product, QTY, ExtPrice, TotalPrice - (This line is not in the output it's just to show what each column is for)
25/04/2013,Soup - 12oz,1,3.30,3.30
25/04/2013,Soup - 12oz,2,3.30,3.30
30/04/2013,Cappuccino,1,2.40,2.40
30/04/2013,Cappuccino,1,2.40,2.40
30/04/2013,Cappuccino,2,2.40,4.80
30/04/2013,Cappuccino,1,2.40,2.40
the above is just a quick snippet of whats in the log file

what i want to do is display this result in the following way so that you can quickly see the qty sold and total price.

Date, Product, QTY, ExtPrice, TotalPrice - (This line is not in the output it's just to show what each column is for)
25/04/2013,Soup - 12oz,3,3.30,9.90
30/04/2013,Cappuccino,5,2.40,12
I read the csv into an arraylist and have tried various ways to try to accomplish this but without success. What I'm not sure about is if this is the best way to try to do what I want or if it's even possible having the data in that format

If anyone could please point me in the right direction it would be greatly appreciated

Thanks

Paul.