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 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
praseena prahlad
il 19 Giu 2016
Commentato: Star Strider
il 19 Giu 2016
if true
% code
end
0 Commenti
Risposta accettata
Star Strider
il 19 Giu 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Entering Commands in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!