Script that parses out the Timestamp, URL, and port of an IIS6 Server Log.

LogCleansing.py

import os

directory = "D:\INFOWEBAPPSLOGS\W3SVC1618619580\\"
fileList = os.listdir(directory)
for fname in fileList:
	filePath = directory + fname
	a = open(filePath)
	c = a.readlines()
	for line in c:
		if ("/secretariat/article.xml.asp") in line:
			f = open("C:\Users\jtan\OUTPUT.LOG", "a")

			lineList = line.split(' ')
			lineNew = " ".join(lineList[0:6]) + "\n"

			f.write(lineNew)
			f.close()