Use Regex to create CSV of raw access logs.

Apache Access Logs to CSV with regex

<?php
/*
^(.+).log(?:\.(?:\d+))?(?:\.gz)?\:((?:\d|\.)+)\s-\s-\s\[((?:\d{2})\/(?:\w{3,4})\/(?:\d{4})):(\S+)\s\+(?:\d+)\]\s\"GET \/wp-content\/uploads\/(?:mp3s\/)?(\S+)\s\S+\s(\d{3})\s\d+\s\S+\s\"(.*)\"$
*/
$re = "/^(.+).log(?:\\.(?:\\d+))?(?:\\.gz)?\\:((?:\\d|\\.)+)\\s-\\s-\\s\\[((?:\\d{2})\\/(?:\\w{3,4})\\/(?:\\d{4})):(\\S+)\\s\\+(?:\\d+)\\]\\s\\\"GET \\/wp-content\\/uploads\\/(?:mp3s\\/)?(\\S+)\\s\\S+\\s(\\d{3})\\s\\d+\\s\\S+\\s\\\"(.*)\\\"$/mi";
$file = file_get_contents('search_results.txt');
preg_match_all($re, $file, $matches, PREG_SET_ORDER);
foreach($matches as $match) {
	$comma_separated = implode("`,`", $match);
	echo '`'.$comma_separated . "`<br />";
}
?>