hello all, I want to place all strings in a column , and at the same time ignoring all the '#N/A' string from all the columns..and instead of, place the next strings from next colum .after that i wil get a sheet of 2874 rows of strings in one column
조회 수: 1 (최근 30일)
이전 댓글 표시
if true
% code
end
댓글 수: 0
채택된 답변
Star Strider
2016년 6월 19일
This seems to work:
[d,s,r] = xlsread('praseena prahlad knnclass.xls');
sc = s(:); % Create Column
idx = (cellfun(@(x)~strcmp(x,'#N/A'), sc, 'UniformOutput',false)); % Create Index
Result = sc(cellfun(@(x) isequal(x,1), idx)) % ‘Result’ is ‘sc’ Where ‘idx == 1’
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Entering Commands에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!