how to delete rows that have string in file?

I want to delete the rows after the date. I tried using data(strcmp(data(:,1), 'END'), :) = [];. My data is 9*23 cell file. Can anyone tell me how to do in a loop?

'5/18/2015'
'END'
'ERROR(s) Encountered:'
''
'Check calibration'
'MVOR - Up or Down Sensor MilliVolt Over-Range value encountered!'
'Check gain adjustments or incident light conditions.'
''
'Check DLC DATE'

Answer 1

[Walter Roberson]

data( find(strcmp(data(:,1), 'END'), 1, 'first'):end, :) = [];

Answer 2

[Sonisa]

This is not working. I have attached a screenshot of my work. I want to delete after the date in each cell. For eg. in {1,1} cell there is 365*1 cell and I need data until the date.

Hope the screenshot will help.

Thanks again

[Walter Roberson]

It works fine for me on your sample data.

data = {'5/18/2015'
'END'
'ERROR(s) Encountered:'
''
'Check calibration'
'MVOR - Up or Down Sensor MilliVolt Over-Range value encountered!'
'Check gain adjustments or incident light conditions.'
''
'Check DLC DATE'
};

data( find(strcmp(data(:,1), 'END'), 1, 'first'):end, :) = [];

This leaves data as {'5/18/2015'}

[Sonisa]

Thank you. It works finally.