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 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
praseena prahlad
am 19 Jun. 2016
Kommentiert: Star Strider
am 19 Jun. 2016
if true
% code
end
0 Kommentare
Akzeptierte Antwort
Star Strider
am 19 Jun. 2016
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’
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Entering Commands finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!