ismember on cell array and remplace values

Hi, I am trying to use ismember and replace values but getting an error. Any hint? Thanks

    c1={'ESP00021';'ESP00023';'ESP00023';'ESP00025'};
    c2={'ESP00023';'ESP00025'};
    d2=[5;26];
    d2=num2cell(d2);
    [~,idx] = ismember(c2,c1,'rows'); 
    c1(idx) = d2;

error: Subscript indices must either be real positive integers or logicals. % probably because I have many repeated values in c1.

[Adam]

What is the error? For starters though:

c1(idx) = d2;

using parentheses is trying to change an element of a cell array and will expect a cell to be passed to it.

[sensation]

error: Subscript indices must either be real positive integers or logicals. % probably because I have many repeated values in c1

Answer 1

[Stephen23]

c1={'ESP00021','ESP00023','ESP00023'}; % a row vector!
c2={'ESP00023','ESP00025'};            % a row vector!
[~,idx] = ismember(c2,c1,'rows');

Question: how many matching rows do you have?

Answer: none.

Both of the cell arrays constitute exactly one row. Those two rows are different (both the contents and number of elements), so there are no matching rows and the output idx would not be a valid index... if it worked at all, which I doubt because ismember is not specified to work with cell array input and the 'rows' option. Neither does it work when I tried it with numeric arrays with a different number of columns:

>> [~,idx] = ismember([1,2,3],[45,45],'rows')
Error using ismember>ismemberlegacy (line 276)
Inputs A and B must be matrices with the same number of columns in the 'rows' case.

The cannot be fixed by simple removing 'rows' because the second char vector in c2, 'ESP00025', does not match any char vector in c1 so the second index value will still be zero (not a valid index).

What are you actually trying to achieve?

http://xyproblem.info/

[sensation]

so with is member I can not get desired result that is:

c1={'ESP00021';'5';'5';'26'};?

Thanks

[sensation]

my mistake, now its a row vector! by running the upper code in cmdwin I get:

    'ESP00021'
    [       5]
    'ESP00023'
    [      26]

[sensation]

I already this that...and the result is in my comment above when doing c1(idx) = d2;

    'ESP00021'
    [       5]
    'ESP00023'
    [      26]

and I want to get:

    'ESP00021'
    [       5]
    [       5]
    [      26]

since each row of c2 corresponds to the row of d2. They have the same number of elements. Sorry cause of the confusion! Thanks

[Stephen23]

Of course we can do that:

>> c1 = {'ESP00021';'ESP00023';'ESP00023';'ESP00025'};
>> c2 = {'ESP00023';'ESP00025'};
>> d2 = [5,26];
>> [idm,idx] = ismember(c1,c2);
>> c1(idm) = num2cell(d2(idx(idm)))
c1 = 
    'ESP00021'
    [ 5]
    [ 5]
    [26]

[sensation]

Thanks for your answer! why num2str conversion btw? Cheers

[Stephen23]

"why num2str conversion btw?"

Because your first comment clearly showed that you wanted the output to be char vectors in a cell array. So I gave you char vectors in a cell array. Then in a later comment you apparently changed your mind and showed that you wanted scalar numeric in a cell array, and so I removed the num2str conversion.

I cannot read your mind, so I have to follow what you show/explain in your comments, which I tried to do as best I can.