Thanks, Massimo.
Its refreshing to get a thoughtful answer instead of an explanation of why I
don't really want what I asked for...
Mike Vislocky
...
> To import the logs into a spreadsheet: with NoteTab again, I do a
> search & replace on the entire file for some unique sequence of
> characters. Let's take a typical log entry:
>
> 208.19.16.210 - - [03/Apr/2001:10:35:09 -0400] "GET /butterfly.html
> HTTP/1.0" 200 4894
> "http://www.google.com/search?q=butterfly+sardinia" "Mozilla/4.0
> (compatible; MSIE 4.01; Windows 95)"
>
> I want to be able to sort the log file by IP, date and file
> requested. I think this would be more or less what you need, right?
> To *cut* the line in three blocks, I tell NoteTab to S&R the
> following: every
> space-space-space[
> (the sequence between IP and date)
> with
> space|space-space-space[
> (I'm simply inserting a space + | between IP and date)
>
> At this point, any spreadsheet/database would let me import the text
> file and ask for a column identifier: I choose the | and I get a nice
> two-block table that I can sort either by IP or date
>
> If I need the third block (requested file) I run another S&R before
> importing. Something like
> search for "GET /
> and replace with "GET | /
...
+------------------------------------------------------------------------
| This is the analog-help mailing list. To unsubscribe from this
| mailing list, go to
| http://lists.isite.net/listgate/analog-help/unsubscribe.html
|
| List archives are available at
| http://www.mail-archive.com/[email protected]/
| http://lists.isite.net/listgate/analog-help/archives/
| http://www.tallylist.com/archives/index.cfm/mlist.7
+------------------------------------------------------------------------
