清空筛选条件
清空筛选条件

how to delete rows that have string in file?

2 次查看（过去 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 中查找有关 Low-Level File I/O 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by