Script for deleting extra rows

Hi,

I am an oceanographer ,so I have to deal with large data gaps . My problem was that I need a script or a function that deletes extra rows(present due to missing data ) from my data set plus it would be a lot easier if I could have something that would would delete specific rows that are not equivalent to my given time stamp .. I have Matlab 2013a..

Thank you!

Answer 1

[CAM]

Try this to remove rows with blank Depths:

[~,~,dataIn] = xlsread(fileName, worksheetName);
index = ~cellfun(@isempty, dataIn(:,2));  % The Depth column
dataCleaned = dataIn(index, :);

I am not clear on the second part of your question. Do you mean you have a defined set of time stamps, and you want to see if you can find matches in the incoming data?