I have certain performance analysis work to do everywork, one is to
reading from a IIS log file in W3C format, the other is a Windows
performance monitoring log in CSV format.
For the first one, I need to open it in Excel, delete its first 3
lines, then delete a few more words, and then divide the bulk text
into columns by spaces using "Text to Column" function, filter the
Excel file etc., and find out the top 10 time consuming request. I did
these every day for almost year before finally realized there is an
easier way.
The other one is simpler, first I need to format the first cells in
time format, select two columns, then insert a chart. This could also
be done by Macro.
As for plain text file, I can use Visual Studio 2002 which supports
temporary macros.
No comments:
Post a Comment