how to delete rows that have string in file?

1 次查看（过去 30 天）
Sonisa
Sonisa 2016-1-12
评论： Sonisa 2016-1-12
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'

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2016-1-12
data( find(strcmp(data(:,1), 'END'), 1, 'first'):end, :) = [];

更多回答（1 个）

Sonisa
Sonisa 2016-1-12
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
  2 个评论
Walter Roberson
Walter Roberson 2016-1-12
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'}

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Scope Variables and Generate Names 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by