comparing string with cell from table
1 view (last 30 days)
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]
0 Comments
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
See Also
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!