Is there a way to use ISMEMBER to obtain specific rows of data in a cell array?

21 Ansichten (letzte 30 Tage)
I'm attempting to use ISMEMBER in order to obtain specific rows of data in a cell array. The code I'm currently using is:
% Clear WS variables and the comand window
clear all;
clc;
% Create a pair of cell arrays of strings
C = ["20749";"20750";"20751"];
A = cellstr(C);
D = ["20749" "11" "ABC-21"; "1000" "35" "XYZ-54"; "20749" "113" "BXT MNT"; "20750" "400" "ABC-21"; "2000" "35" "ABC-01"; "20751" "42" "SRT-29"; "2001" "60" "ARN-21";"20750" "80" "ABC-21"; "20749" "25" "ABC-21"; "3000" "14" "ABC-21"];
B = cellstr(D);
% Array elements that are members of set array
[Lia,Locb] = ismember(A,B,'legacy');
I've run into a problem where Locb contains the lowest index in B for each value, instead of all the indices. Eventually I'd write the applicable rows of data in B into a separate variable. Is there a technique I could utilize that would allow for this? Or will I need to use a different function/technique?
Thanks.

Akzeptierte Antwort

Brad
Brad am 8 Feb. 2018
It appears I've answered my own question with the following solution;
E = B(ismember(B(:, 1), A), :);

Weitere Antworten (0)

Kategorien

Mehr zu Data Type Identification finden Sie in Help Center und File Exchange

Tags

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by