I've got an logfile like:
Start dump db_name1 : Wed Oct 30 15:08:47 MET 2002
Ready dump db_name1 : Wed Oct 30 15:14:46 MET 2002
Start dump db_name2 : Wed Oct 30 15:14:46 MET 2002
Ready dump db_name2 : Wed Oct 30 15:15:36 MET 2002
Start dump db_name3 : Wed Oct 30 15:15:36 MET 2002
Ready dump db_name3 : Wed Oct 30 15:17:00 MET 2002
What I want to do is make a file which looks as follows:
db_name1 db_name2 db_name3
Oct 30 5:99 0:50 1:24 <- duration of dump
So that everytime I dump the databases a line is added in the file.
How can I do this ? With AWK ? or something else.
Especially how can I subtract the times ?
I hope that somebody can help me.