Apache Access Log Parsing using Regular Expression

Anonymous — Thu, 27 Dec 2018 09:16:45 GMT

Hello,

I have an Apache Access Log (200MB) in the format :

127.0.0.1 - - [05/Feb/2012:17:11:55 +0000] "GET / HTTP/1.1" 200 140 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.5 Safari/535.19"

With following Components : tFileInputDelimited (choosing the log file) -> tMap-> tMysqlOutput I was able to export the Logs to my Database. However, I would like to split the values available in the log for instance into separate column in the format:

127.0.0.1 (col1)
05/Feb/2012:17:11:55 +0000 (col2)
GET / HTTP/1.1 (col3)
200 (col4)
140  (col5)
Mozilla/5.0 (Windows NT 6.1; WOW64) (col6)

According to the other similar threads, this is achievable by using regular expressions in the tMap. But I am very new to Talend and regular expressions parsing in Talend. Could anyone please help me how I could achieve this?

Re: Apache Access Log Parsing using Regular Expression

akumar2301 — Thu, 27 Dec 2018 11:56:02 GMT

try tApacheLogInput

topic Re: Apache Access Log Parsing using Regular Expression in Talend Studio

Apache Access Log Parsing using Regular Expression

Re: Apache Access Log Parsing using Regular Expression