finding specific elements in a cell vector

1 次查看（过去 30 天）
Sabbas
Sabbas 2012-8-3
Dear all,
I have 10 excel files
some files contains a column
A={
'1W'
'1W'
'1W'
'1W'
'1W'
'1W'
'1W'
'1W'
'1W'
'1W'
'1W'
}
and some other excel files contain the following column
A={'1W'
'1W'
'1W'
'1W'
'1W'
'2W'
'1W'
'1W'
'2W'
'1W'
'1W'}
I want to constract an if statement that will say
If A contains ONLY '1W'
'do that'
end
and another one that will say
if A contains ONLY '1W' AND '2W'
'do that'
end
thanks

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

回答（2 个）

Honglei Chen
Honglei Chen 2012-8-3
uniqueA = unique(A);
if isequal(uniqueA,{'1W'})
...
elseif isequal(uniqueA,{'1W';'2W'})
...
end
Azzi Abdelmalek
Azzi Abdelmalek 2012-8-3
编辑：Azzi Abdelmalek 2012-8-3
n=length(A)
if sum(cell2mat(regexp(A,'1W')))==n
test=1
elseif sum(cell2mat(regexp(A,'1W|2W')))==n
test=2
end
  2 个评论
Andrei Bobrov
Andrei Bobrov 2012-8-3
>>A={'1W'
'1W'
'1W'};
>>n=numel(A);
>> sum(cell2mat(regexp(A,'1W|2W')))==n && sum(cell2mat(regexp(A,'1W')))==n
ans =
1
?
Azzi Abdelmalek
Azzi Abdelmalek 2012-8-3
编辑：Azzi Abdelmalek 2012-8-3
the order is important, when the first condition is true, the second is skiped even it is true. example:
if 2==2;test=1;elseif 3==3 test=2,end
%the result will be test=1 ,

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by