Urgent help to change value of log file

[rakeshuma]

Hi,
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.

samplelog file
2011-02-17 12:58:31 172.30.9.191 GET /Gatekeeper.aspx type=wel&id=wel-epub/MMS1234567.epub 80 - 180.129.52.192 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


Please help

[UrgeToLearn]

Hey if u r trying to extract this unique ID then use the concept of substring. Please specif your question more clearly..

You need to replace the log files entries or you wan tto take some data from the log file and append it to the title??

[Eranga]

How this is related with Java? This is a Java forum, please focus on related stuff.

[rakeshuma]

Hi,

thanks for reply. ok my logfile is exyymmdd.log now i need to read the log file using java program of previous day i.e (exyymmdd, -1) after reading the log file i need to check the value which start with MMS12345.book(numbers are changing) when I come across the MMS12345.book in the log , i need to map it with a xlsheet which has the corresponding title, and then replace the MMS12345 with that title.

The above can i do in one single java program.

Kindly help me with ur valuable input

Thanks for your patience and time

Regards
Uma

[Eranga]

Just looking at your requirement I can say that it's possible to done with Java.

Did you try to do anything on that yet?