清空筛选条件
清空筛选条件

How to replace the matching cell

3 次查看（过去 30 天）
Mekala balaji
Mekala balaji 2016-8-6
编辑： Walter Roberson 2016-8-9
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.
  4 个评论
显示 2更早的评论
Stephen23
Stephen23 2016-8-8
编辑：Stephen23 2016-8-8
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
Mekala balaji 2016-8-9
编辑：Walter Roberson 2016-8-9
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

请先登录，再进行评论。

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

采纳的回答

Stephen23
Stephen23 2016-8-8
编辑：Stephen23 2016-8-8
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'

更多回答（1 个）

Walter Roberson
Walter Roberson 2016-8-6
mask = strcmp(YourCell(:,1), 'fail');
YourCell(mask,[3 6]) = {'Outspec'};
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2016-8-6
The entire row is not changed. Only columns 3 and 6 are changed. Did you try the code?
Mekala balaji
Mekala balaji 2016-8-8
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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Classification Ensembles 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by