comparing string with cell from table
Show older comments
I like to find how many times the word TC is present is column 4 of the table data. The counter stays on zero. Can someone pleae tell me why? I wrote this code:
for YY=1:z
TC{1,YY} = (0);
[rowX, columnY] = size(data{1,YY} );
for qq = 1:rowX
vvv{1,1} = data{1,YY}(qq,4);
Index2{1,1} = strcmp(vvv{1,1}(1,1), 'TC');
if Index2{1,1}==1
TC{YY} = TC{YY}+1;
end
end
end
[EDITED, Jan, Code formatted]
Answers (1)
Jan
on 24 May 2018
What is "data"?
What about:
TC = zeros(1, size(data, 2));
for YY = 1:size(data, 2)
col4 = data{1, YY}(:, 4);
TC(YY) = sum(strcmp(col4, 'TC'));
end
2 Comments
Eliah Verbeemen
on 24 May 2018
Edited: Eliah Verbeemen
on 25 May 2018
Jan
on 26 May 2018
Please post the contents of the tables.
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!