How to find a blank cell and remove the line that the blank cell is in

Hi All, 

My data file looks like the following

 

Shop,User,InOut,Date,Time,None,,,

301,1005,SW,30/12/2010,09:30:00,,,,

301,1005,EW,30/12/2010,17:45:00,,,,

301,1005,SW,31/12/2010,,,,,

301,1005,EW,31/12/2010,17:52:00,,,,

 

As you can see above, line three does not contain any time information. I need to search the file for all instances like this and delete these lines as they cause an inout error on the program that this file is being parsed to.

 

Solutions to this would be greatly appreciated

Mark

Parents
No Data
Reply Children
No Data