
lkhlc
New User
Dec 2, 2013, 8:13 PM
Views: 3255
|
Adding Column values and more (not spam thankyou!)
|
|
|
Seeking help for the following. Appreciation is massive! Presented with a flat file that contains two columns. Column one is a part number. Column two is a quantity number. The site contains numerous duplicate part numbers from various locations. (location itself does not matter) The need is for a fast a painless way to generate a single entry for each part number , having totaled the quantity number, so five locations can be merged into one part number to show how many total of each part number is 'in stock'. Example of file: 04054017280,22 04054017500,29 04054018280,94 04054017280,12 04054017500,19 04054018280,24 Desired output: 04054017280,34 04054017500,48 04054018280,118 The file can be anywhere from a few k's to many megs in size. Seeking a simple, fast and low resources snippet if possible. The output will write to a file. Comma separated data. Thank you very much for your help in this matter.
|