Log Files: Dealing with Inconsistent Field Delimeter

Salam, Log files are big. ProcessingĀ  itĀ  would be cumbersome especially if the field separator are not so unique. Take a look at contain of file example.log below : “209.34.23.99”,6667,”Rembau, NSembilan,Malaysia”,”GET /phpmyadmin “,404 “238.34.23.99”,80,”Selangor”,”GET /phpmyadmin/ ,200 “21.34.23.99”,9090,”A. Star, Kedah, Malysia”,”GET /phpmyadmin/favicon.ico,404 “120.34.23.99”,6667,”Malysia”,”GET /phpmyadmin/print.css,404 “2.34.23.99”,993,”A. Star, Kedah, Malysia”,”GET /phpmyadmin/phpmyadmin.css.php?lang=en-utf-8,404 At first sight, anybody would agree to […]