First let me say I SUCK at programming.
I can usually read and modify basic scripts but suck at writing them.
I'm hoping that someone can put together a quick script that I can modify later.
Here's the issue...
I get a daily .csv file from our webserver that includes every file a person has accessed the day before.
Unfortunately this list has items I don't need logged, files are listed in order of usage (greatest to least), and in some cases the same file is listed twice because of letter case, and if a file is not accessed at all it is not listed with a zero.
Each day this log has items in a different order or items may not be listed at all if the usage was zero.
How to grab each file (item) listed in the log that I do need, check for duplicates (and add them together), and put the results in the correct order?
I don't necessarily need to update the running log directly as part of the script if I can just copy and paste from another file into the Excel spreadsheet. (2003)
Currently I spend about 15 minutes a day on this to around an hour on Mondays since there are three days to enter.
Now my Boss does not want just the stats for the little website but the stats for the big one as well which may take 2 hours or more to sort though the whole thing.
Data is listed pretty simply as:
"Filename" "Number of times accessed"