how to delete rows that have string in file?

2016 1 12
2 个回答
回答已采纳
更新时间：2016 1 12
1 次查看（30 天）

0 个投票

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'

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

 采纳的回答

更多回答（1 个）

Sonisa
Sonisa 2016-1-12

0 个投票

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'}
Sonisa
Sonisa 2016-1-12
Thank you. It works finally.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by