How can I match a string in a cell array and then pull out data from the row with the match?

Question

L 2018-11-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/428786-how-can-i-match-a-string-in-a-cell-array-and-then-pull-out-data-from-the-row-with-the-match

编辑： Nick 2018-11-9

采纳的回答： L

在 MATLAB Online 中打开

Hello,

I have been struggling to solve this problem on my own after combing the internet for solutions. Here is my code below.

A = {'Red123' 'Bob' '08/11/2018' 'Blah'; 'Red456' 'Jim' '11/08/2018' 'Meh'; 'Blue123' 'Bean' '02/11/2018' 'MoreMeh';...
'Blue456' 'Dale' '05/05/2005' 'Nope'};
IDTag = 'Blue123';
check = strcmp(A,IDTag);

check returns a 4x4 logical array with a 1 where I would expect it. What I'd like to figure out how to do is to then take the data after the match in the row (in this case it would be A(3)). So I'd like to have my script find the match and then assign A(3,2) and A(3,3) to variables to be passed off elsewhere. How can I do this dynamically and autonomously so when I need to pass in variables to check this list, I can quickly match and pull out data?

To reiterate, I want to match on Blue123, and if it is a match, I want to assign 'Bean' and '02/11/2018' to two different variables for later use. If I later want to match a different IDTag, I want it to do the same thing.

Thank you!

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

请先登录，再进行评论。

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

Answer 1

L 2018-11-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/428786-how-can-i-match-a-string-in-a-cell-array-and-then-pull-out-data-from-the-row-with-the-match#answer_345911

在 MATLAB Online 中打开

Go figure, a few minutes after posting the question I stumble across something elsewhere that helps me discover the answer I was looking for.

Solution to my question

[~ idx] = ismember(IDTag,A);
Name = B(idx,2);
Date = B(idx,3);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

madhan ravi 2018-11-8

编辑：madhan ravi 2018-11-8

A small correction I suspect it should be

Name = A(idx,2);

Date = A(idx,3);

from the above details you provided in the question because B is not defined in the above

请先登录，再进行评论。

Answer 2

Nick 2018-11-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/428786-how-can-i-match-a-string-in-a-cell-array-and-then-pull-out-data-from-the-row-with-the-match#answer_345904

编辑：Nick 2018-11-9

在 MATLAB Online 中打开

For now i am assuming the ID is always in the first column. You could have the logical matrix repeat itself and then use that as an index:

% your code
A = {'Red123' 'Bob' '08/11/2018' 'Blah'; 'Red456' 'Jim' '11/08/2018' 'Meh'; 'Blue123' 'Bean' '02/11/2018' 'MoreMeh';...
'Blue456' 'Dale' '05/05/2005' 'Nope'};
IDTag = 'Blue123';
check = strcmp(A,IDTag);
% change the check matrix to have the entire row the same as the first row
check = repmat(check(:,1), 1, size(check,2));
correspondingData = A(check);
name = correspondingData{2};
date = correspondingData{3};

alternatively you can also do:

index = find(check(:,1)==1);
correspondingData = A(index,:);
name = correspondingData{2};
date = correspondingData{3};

2 个评论
显示无隐藏无

L 2018-11-8

Both above didn't work for me, but it could have been a misunderstanding in the question as the results I got from your code gave me the IDs and not the information I was looking for after those IDs when they match.

I did figure it out though, below is what I was looking for.

Nick 2018-11-9

I just saw i made a mistake in the answer above (accidantly used A instead of correspondingData). Thats the reason it did not work, edited my answer to correct for this error. I'm glad you found a solution already.

请先登录，再进行评论。