How to detect row index

Question

Mekala balaji 2018-4-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/394669-how-to-detect-row-index

评论： Rik 2018-4-14

Hi, I have the cell array of column as below:

VA
Star
/
:
Status
Star
/
end
:
positive
Status
1
4
12
det
STDEV
/
end
:
finish
Star
/
end
:
positive
Status
:
KLA
STU
end
status

Now, I want to detect the row index of "Star" when below strings appears in consecutive rows.

Star
/
end
:
positive
Status

In this case, 7 (6th row white space)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Rik 2018-4-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/394669-how-to-detect-row-index#answer_315101

The code below should do the trick:

a={'VA';'Star';'/';':';'Status';'';'Star';'/';'end';':';'positive';...
    'Status';'';'1';'4';'12';'det';'STDEV';'/';'end';':';'finish';'';...
    'Star';'/';'end';':';'positive';'Status';':';'KLA';'STU';'end';'status'};
b={'Star';'/';'end';':';'positive';'Status'};
[~,index]=ismember(a(:),b(:));
starting_rows=strfind(index',1:length(b));

2 个评论
显示无隐藏无

Mekala balaji 2018-4-14

How does this works:

starting_rows=strfind(index',1:length(b))

Rik 2018-4-14

The trick is that ismember finds the positions where elements of b can be found in a. This means that you are looking for the positions in index where a subvector [1 2 3 4 5 6] starts. You can easily do this by pretending the vectors are strings and using strfind. You don't even need a conversion to char (in Octave you might). The transpose is there to convert the column vector to a row vector.

This method requires the elements of b to be unique.

请先登录，再进行评论。