Importing Apache Logs

[uemtux]

Hello Everyone,

I'm trying to write a database to run reports on apache logs. Does anyone have a tried, tested, and true way of splitting an apache log line into its constituent parts? I've found a few Perl regexes that do the job, so I can always use Applescript to do shell script and write a little perl program that splits all the 'fields' of the log onto separate lines for interpretation by FileMaker, but if anyone knows of a FileMaker native implementation of apache log parsing I'd love to know!

Here is a sample apache log line if anyone needs (IPs Xed out):

XXX.XXX.XXX.XXX - - [05/Aug/2012:23:57:39 -0400] "GET /SpryAssets/SpryMenuBarVertical.css HTTP/1.1" 304 - "-" "Mozilla/4.0 (compatible;)" XXX.XXX.XXX.XXX XXX.XXX.XXX.XXX

Thanks!

[Lee Smith]

What do you want to see as the result?