I need to filter and compound the values in .CSV files.
This is for a Toshiba output log file
What I need to happen:
Take the highest value from certain columns and total at the end
The final file will only have 9 columns; number, dept, code, copy, color copy, scan, print, fax
Also any rows without any values remove.
I need this done ASAP.
so great communication and effecieny is needed
a sample sile has been uploaded.