How to get row index satisfy the condition in cell array

3 次查看(过去 30 天)
Hi,
I have celle array, and want to find row index where the cell value is equal to 1.
data:
'Group1' 'PVT' 'Power' '01-06-2019' [0]
'Group1' 'PVT' 'Power' '01-06-2019' [1]
'Group1' 'PVR' 'VFT' '01-06-2019' [1]
'Group1' 'PMR' 'VGA' '01-06-2019' [1]
I want to get row where the value is equal to 1 in last column. I tried below code but does not work.
Method1:
IndexC = strfind(cell2mat(data{:,end}),'1');
method2:
idx2=strfind(data(:,end),'1');
Both does not worlk.

采纳的回答

madhan ravi
madhan ravi 2019-6-29
The last column doesn't seem to be a char:
data(cell2mat(data(:,end))==1,:)

更多回答(0 个)

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by