Urgent help to change value of log file
I have a daily generated iis logfile , inside the logfile there is an id which is unique now i need to replace the id to the title and that title and corresponding ID is present in xlsheet.
So now i need to check each row having the title aginst the logfile row and need to replace accordingly.
2011-02-17 12:58:31 172.30.9.191 GET /Gatekeeper.aspx type=wel&id=wel-epub/MMS1234567.epub 80 - 126.96.36.199 MobileRead/1.0+CFNetwork/485.12.7+Darwin/10.4.0 500 0 64 131072 172265
MMS1234567 needs to be replaced to title Charles Darwin similarly 200 ID are there