1.

Solve : help!!! select lines based from columns?

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!



Discussion

No Comment Found