script to delete lines from a txt file if pattern matches

Shell Programming and Scripting
1

File

6 dbnawldb010-b office Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/09/11 03:24:04
42 luigi-b IPNRemitDB Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/10/11 00:41:36
6 ebs-sqldev1-b IPNTracking Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/09/11 23:45:19
6 pmemcfdb450-b WMD_FAX01 Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 03/08/11 18:42:13
42 luigi-b IPNRemitDB Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/10/11 00:41:36
6 odysseycl-b OHDSH5 Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 03/09/11 19:09:39
6 odysseycl-b Odyssey Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 03/09/11 18:59:01
150 ebs-sql1-b EBSCClaimStore Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 03/09/11 20:40:25

i need to remove all those lines; if the 6th coloumn (date) is 03/09/11 (today's date) and the 7th column (time) is less than 06:00:00

---------- Post updated at 01:31 AM ---------- Previous update was at 01:30 AM ----------

from the above file, the script should remove only the below line which is the only one matches my pattern

6 dbnawldb010-b office Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/09/11 03:24:04
2 
 awk '{if ( $6 == "03/09/11"  ) {split($7,a,":") ;    if ( a[1] > 6 ){print}}  else {print} }'  filename
1 Like
3

thank you so much, working like a dream.
Can you pls explain how exactly its working

4

if ( coloumn == "03/09/11")
{
split column 7 on ":" ;
take first element i.e hours
if ( hours > 6 )
print entire line
}
else
print entire line

5

thank you so much man, so kind if yo...:b: