Dec 2, 2013, 8:13 PM
Post #1 of 3
Seeking help for the following. Appreciation is massive!
Adding Column values and more (not spam thankyou!)
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:
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.