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 天）

显示更早的评论

praseena prahlad 2016-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/290713-hello-all-i-want-to-place-all-strings-in-a-column-and-at-the-same-time-ignoring-all-the-n-a-st

评论： Star Strider 2016-6-19

采纳的回答： Star Strider

knnclass.xls

在 MATLAB Online 中打开

if true
  % code
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Star Strider 2016-6-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/290713-hello-all-i-want-to-place-all-strings-in-a-column-and-at-the-same-time-ignoring-all-the-n-a-st#answer_225968

在 MATLAB Online 中打开

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’