Answer» Here's what i need to do.
I need to edit the contents of file1 such that it will contain all lines whose COLUMN 2 are GREATER than or equal to 04/22/2005 AND Col6 is NOT equal to SU
from this file Col1 Col2 Col3 Col4 Col5 Col6 Job1 04/21/2005 03:30:36 04/22/2005 03:32:29 FA Job2 04/21/2005 03:32:31 04/22/2005 03:34:37 TE Job3 04/22/2005 03:34:40 04/23/2005 03:34:43 SU Job4 04/23/2005 03:34:45 04/23/2005 03:34:48 FA Job5 04/23/2005 03:34:52 04/23/2005 03:42:12 FA
to this Job4 04/23/2005 03:34:45 04/23/2005 03:34:48 FA Job5 04/23/2005 03:34:52 04/23/2005 03:42:12 FA
can the sed COMMAND do it? if yes, what would be the command. IM not that familiar with sed :(
if sed can't do it? how can i get this done?
thanks!
|