Quote: Originally Posted by BriceH
I have now modified it to do everything you want, including putting the output in a new file. Please report back on how well this works.
Seems to work exactly as expected. Very nice.
Since the input TXT file is clearly in a CSV (comma-separated variable) format that is suitable for importing into Excel, it also would seem that a spreadsheet solution with a simple SUM/DSUM function of some kind should also exist... since the data is already prepared and it's just a matter of adding the values in cells from one column based on matching cells in other columns being the criteria.
Give me one day.
(very simple COBOL program as well)