Hi,
This may be a bit longwinded but I'm hoping to find a direction on what I can do. Many things have been tried but none seem to do what I'm after. If anyone has any suggestions they would be appreciated.
I have 5 text files, logs of different activities done throughout the day. Each file represets 24 hours worth of entries. These files are stored in the same folder. Each day these logs are moved and uniquely renamed(based on the day of the year, 1-365) and a new set of logs is started.
In Excel I have a file that takes the active logs and displays an auto refreshing chart of the activity being recorded. It works well but only references the 5 logs that are live and in use.
I can combine all the inactive logs into one text file for each log type if needed, given that each day can still be sorted/viewed on a chart somehow.
How do I take the inactive logs and chart each days totals to be viewed in one chart? I would need each of the 5 logs to be represented.
In general the logs contents follow the format of:
ZIP, BOXES, DATE
28623, 2, 1/4/2011 9:21:11 AM
28623, 2, 1/4/2011 9:21:12 AM
28616, 1, 1/4/2011 9:26:08 AM
28616, 1, 1/4/2011 9:26:08 AM
28616, 2, 1/4/2011 9:26:19 AM
& the inactive log filenames have a format like:
123_boxes.txt
124_boxes.txt
This may be a bit longwinded but I'm hoping to find a direction on what I can do. Many things have been tried but none seem to do what I'm after. If anyone has any suggestions they would be appreciated.
I have 5 text files, logs of different activities done throughout the day. Each file represets 24 hours worth of entries. These files are stored in the same folder. Each day these logs are moved and uniquely renamed(based on the day of the year, 1-365) and a new set of logs is started.
In Excel I have a file that takes the active logs and displays an auto refreshing chart of the activity being recorded. It works well but only references the 5 logs that are live and in use.
I can combine all the inactive logs into one text file for each log type if needed, given that each day can still be sorted/viewed on a chart somehow.
How do I take the inactive logs and chart each days totals to be viewed in one chart? I would need each of the 5 logs to be represented.
In general the logs contents follow the format of:
ZIP, BOXES, DATE
28623, 2, 1/4/2011 9:21:11 AM
28623, 2, 1/4/2011 9:21:12 AM
28616, 1, 1/4/2011 9:26:08 AM
28616, 1, 1/4/2011 9:26:08 AM
28616, 2, 1/4/2011 9:26:19 AM
& the inactive log filenames have a format like:
123_boxes.txt
124_boxes.txt
