How to do multiple replacements in a cell array

Hi,

I am wondering what is the most efficient way in Matlab to do multiple replacements in a cell array based on the content of a differentt cell array ?

More specifically, I am trying to transform cell1 into cell3 based on the associations defined in cell2 in the most efficient way possible (in other words cell1(:,2) becomes cell3(:,2))

% Cell array data
cell1 = {1, 2, 3, 4, 5; 'A', 'A', 'B', 'C', 'B'; 'AA', 'BB', 'CC', 'DD', 'JJ'}'


% Cell array reference
cell2 = {'C', 'B', 'A'; 'FFFF', 'GGGG', 'HHHH'}'

% Desired output
cell3 = {1, 2, 3, 4, 5; 'HHHH', 'HHHH', 'GGGG', 'FFFF', 'GGGG'; 'AA', 'BB', 'CC', 'DD', 'JJ'}'

Thank you,

[James Tursa]

Are the letters in cell1 column 2 always 'A', 'B', or 'C'?

[Stephen Cobeldick]

Bluegin's "Answer" moved here:

No, unfortunately. There's about 50 differents codes in reality.

Answer 1

[Stephen Cobeldick]

>> [idx,idy] = ismember(cell1(:,2),cell2(:,1));
>> cell3 = cell1;
>> cell3(idx,2) = cell2(idy(idx),2)

[012786534]

Neat, thank you. Could the same thing be accomplished with intersect ?

Something along the lines of :[C,ia,ib] = intersect(A,B, 'stable'); ?