MATLAB: I would like to get an cell array output by matching 2 cell arrays and returning with corresponding matched values from other cell array.

cell arrays

I have 2 cell arrays A(6*1) and B(35*2).

A= {'MEG0522';'MEG0523';'MEG0512';'MEG0513';'MEG0312';'MEG0313'};
B= {'MEG0522','LF';'MEG0523','LF';'MEG0512','LF';'MEG0513','LF';'MEG0312','LF';'MEG0313','LF';'MEG0342','LF';'MEG0343','LF';'MEG0122','LF';'MEG0123','LF';'MEG0822','LF';'MEG0823','LF';'MEG0533','LF';'MEG0532','LF';'MEG0543','LF';'MEG0542','LF'{'MEG0923','RF';'MEG1212','RF';'MEG1213','RF';'MEG1223','RF';'MEG1222','RF';'MEG1412','RF';'MEG1413','RF';'MEG0943','RF';'MEG0942','RF';'MEG0933','RF';'MEG0932','RF';'MEG1232','RF';'MEG1233','RF'};

I would like to get an output by matching A with B, returning a cell array say C(6*2) with A values in the column 1 and corresponding B values in column 2.

C = {'MEG0522','LF';'MEG0523','LF';'MEG0512','LF';'MEG0513','LF';'MEG0312','LF'};

Values will not be in an orderly fashion. I would appreciate any support from community members.

Best Answer

Please, let me know if the following sentence solves your problem:

B(ismember(B(:,1),A),:)

Related Solutions

MATLAB: How to obtain one cell of output data from multiple cells

Very simple. Try this:

%this is a simple version of you set of cells
U = { cell(3,1) ; cell(2,1) ; cell(4,1) }
%here you concatenate them and put them into a cell
B = {cat(1,U{:})}

MATLAB: How to sort the data from regexp

There is no real need for the intermediate regexp, you can get it all with just one regular expression:

tokens = regexp(TXTmod, '(R\d\d\w)/\w*(\d\d\d\d)\D\>', 'tokens'); %You were missing a \d in your regexp (which was captured by the \w* so it didn't matter)

Or more efficient (but a bit longer):

tokens = regexp(TXTmod, '\<(R\d{2}[A-Z])/(?:(?:\d{4})?[A-Z]+)?(\d{4})[A-Z]\>', 'tokens')

Note the inefficiency in your original expression: The \w*\d\d\d in your first regular expression is going to cause a lot of backtracking by the regular expression engine because the \w* is always going to match the next three \d. Because * is greedy, at first the engine is going to match the three digits with \w* and find then that it can't match 3 digits after. So it's going to backtrack one digit, match the first two digits with \w*, the 3rd digit with \d and find that it still can't find a match for the next two \d. it will have to backtrack two more times until \w* only match the letters and the three \d match a digit.

The new regular expression matches a optional group of 4 digits followed by 1 or more letter and then capture the final groups of 4 digits before the last letter. I've also added a start of word match: \<.

Other note: To rearrange the tokens of each string into a two column cell array:

cellfun(@(t) vertcat(t{:}), tokens, 'UniformOutput', false)

Best Answer

Related Solutions

MATLAB: How to obtain one cell of output data from multiple cells

MATLAB: How to sort the data from regexp

Related Question