How to replace the matching cell

Hi,

I have the below cell matrix,

pass OK Out OK OK Out
pass OK Out OK OK Out
fail OK Out OK OK Out
pass OK Out OK OK Out
pass OK Out OK OK Out
fail OK Out OK OK Out

If in first column of particular row is "fail" then replace the Out as "Outspec". Kindly someone help how to do this.

[Stephen23]

@Mekala balaji: please show us the desired output as well.

[Mekala balaji]

My output should be:

pass     OK    Out       OK       OK       Out
pass     OK    Out       OK       OK       Out
fail     OK    OutSpec   OutSpec  OK       OutSpec
pass     OK    Out       OK       Out      Out
pass     OK    Out       OK       OK       Out
fail     OK    OutSpec   OutSpec  OutSpec  OutSpec

[Stephen23]

Your input and output arrays do not match, according to your description: your output has "Out" in position (4,5), but the input does not. Where does this "Out" come from ?

Also in columns four and five you have three "OutSpec", but your input array does not show any "Out"s in those columns, as they both contain only "OK"s, and you did not mention that you want to do anything with "OK". Where did these "OutSpecs"s come from?

[Mekala balaji]

Sir,

below is my modified input ( I forgot to show this, which is given below):

pass OK Out OK OK Out
pass OK Out OK OK Out
fail OK Out Out OK Out
pass OK Out OK Out Out
pass OK Out OK OK Out
fail OK Out Out Out Out

Answer 1

[Stephen23]

This might do what you want:

inp = {...
'pass','OK','Out','OK','OK','Out';...
'pass','OK','Out','OK','OK','Out';...
'fail','OK','Out','Out','OK','Out';...
'pass','OK','Out','OK','OK','Out';...
'pass','OK','Out','OK','OK','Out';...
'fail','OK','Out','Out','Out','Out';...
}; % from your comment above
out = inp;
idx = strcmp(out(:,1),'fail');
out(idx,2:end) = strrep(out(idx,2:end),'Out','OutSpec')

output:

out = 
  'pass'    'OK'    'Out'        'OK'         'OK'         'Out'    
  'pass'    'OK'    'Out'        'OK'         'OK'         'Out'    
  'fail'    'OK'    'OutSpec'    'OutSpec'    'OK'         'OutSpec'
  'pass'    'OK'    'Out'        'OK'         'OK'         'Out'    
  'pass'    'OK'    'Out'        'OK'         'OK'         'Out'    
  'fail'    'OK'    'OutSpec'    'OutSpec'    'OutSpec'    'OutSpec'

Answer 2

[Walter Roberson]

mask = strcmp(YourCell(:,1), 'fail');
YourCell(mask,[3 6]) = {'Outspec'};

[Mekala balaji]

Sir,

I only want to replace "Out" as "Outspec", not entire row.

[Walter Roberson]

The entire row is not changed. Only columns 3 and 6 are changed. Did you try the code?

[Mekala balaji]

Sir,

The "Out" is not fixed (it vary, not only in column 3&6). The modified input is below, and in "fail" row, just only replace "Out---> OutSpec"

pass OK Out OK OK Out
pass OK Out OK OK Out
fail OK Out Out OK Out
pass OK Out OK Out Out
pass OK Out OK OK Out
fail OK Out Out Out Out