This is tricky, but perfectly doable ;-) SELECT BaseDateTime, DateTime USING TO_TIMESTAMP(EXTRACT_TOKEN(EXTRACT_TOKEN(Text, 1, '['), 0, ' '), 'dd/MMM/yyyy:hh:mm:ss') AS BaseDateTime, SUBSTR(Text, SUB(INDEX_OF(Text, ']'), 5), 5) AS StrOffset, -- Offset including sign CASE SUBSTR(StrOffset, 0, 1) -- Switch...

Thank you very much for your reply. I have been browsing the forums and I am really impressed with the "service level" and the very positive spirit I tried to find some hints on how to handle the following datetime format: [29/Apr/2005:00:00:02 +0200] TO_TIMESTAMP(EXTRACT_TOKEN(EXTRACT_TOKEN(Text, 1...

Ouch, it seems this is an NCSA dialect that Log Parser does not support....the NCSA input format supports NCSA logs with these fields: RemoteHostName (S) RemoteLogName (S) UserName (S) DateTime (T) Request (S) StatusCode (I) BytesSent (I) Referer (S) User-Agent (S) Cookie (S) However, your log looks...

When I got to know of this fine tool I wanted to try it out on a log file produced by the Domino Web Server. The log file format of this product should be NCSA. This is the first log file line of a randomly picked log file: 23.99.124.106 www.test.com - [29/Apr/2005:00:00:02 +0200] "GET /ECompany/Ced...

Pulling off sessions and visits from a web log file is a rather difficult problem, which can be solved only through heuristics, and Log Parser doesn't offer much help in that direction. There's some other post around here dealing with that. Sorry about that.

Hi All I´m new to LogParser and want to get some info from a NCSA log file. For each url I wonder how could I get average connection time by session and by visit. Any clue appreciatted. Thanks in advance C

If you come up with a plugin and you want to share it, let Mike know, so he can post it for other users to download it! As for your request, we're getting there with the next version :-) Stay tuned!

[QUOTE User="LogParser User : DEinspanjer"]Quote: Yep, the possibility to extend existing input formats would be so nice to have, but it's also a huge pain in the neck..... I didn't know that users could add extra fields to NCSA log files...how's th...[/QUOTE] Apache and Tomcat basically have a series...

Yep, the possibility to extend existing input formats would be so nice to have, but it's also a huge pain in the neck..... I didn't know that users could add extra fields to NCSA log files...how's that achieved? The next version' NCSA input format might support extra fields after the 'classic' fields...

oh I see what you mean. I'm not sure but I don't think you can extend a base input format. That would be a nice feature for a future version though. I don't know how you structured your COM, but without rewriting your object, I don't know how you could make that extra field field available. Someone on...