Lazyweb request: IM log analysis for Trillian?
Thu 1 Jun 2006, 1:35 pm
I’m pretty sure I know the answer to this (and I’m pretty sure it is no), but does anyone have a quick and dirty way to get the log files from the Trillian IM client into a spreadsheet?
I’m looking to review the IM reference service that we provided last year, and I’d like to get information on day of the week, time of day, etc. in a format that we can analyze. Trillian keeps log files in plain text, so it is easy enough to get at the information, but in order to analyze it, I think I’m going to have to do a lot of copying and pasting into Excel.
Any better ideas out there?
- License:
- File under: Social software,Tools
- Comments? One
Hmm… maybe use sed on unix/linux to insert tabs after the day of the week, time of day, and so on? If you’re only looking for that info (rather than the text of the messages) I would think you’d be able to use sed to only grab the “Session Start” text lines, then either replace spaces with tabs or put tabs just before the fields you’re looking for, and then import the resulting file into Excel as tab-delimited. If you know awk it might even be easier. I’ve been amazed at some of the stuff Shane can do with one line of commands using sed and awk.
Comment by Carlos Ovalle — June 8, 2006 @ 9:52 am