MATLAB: 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 colum

pls snd code

if true
  % code
end

Best Answer

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’

Related Solutions

MATLAB: How to convert all the cell in a columns from char to string

Hum! it's not actually that easy as you can't use the syntax yourtable(:, somecolumns) to change the type of the column from cell array to string.

Option 1: use . indexing over the char columns

for columnname = yourcharcolumnnames  %where yourcharcolumnnames is a cell array of the char column names
   yourtable.(columnname{1}) = string(yourtable.(columnname{1}));
end

Option 2: create an auxiliary function for varfun that can take any column type

function column = convertcolumn(column)
   if iscell(column) && ~isempty(column) && ischar(column)
      column = string(column);
   end
end

which you use with varfun:

newtable = varfun(@convertcolumn, yourtable);

MATLAB: Strings

Did you mean??

clear; clc;
   word = lower(input('Enter a word : ','s'));
   letter = input('Guess a character : ','s');
   stat = findstr(word,letter);
   if ~isempty(stat)
       for x = 1 : length(stat)
           fprintf('Character %c macthes with word %s in column %d\n',letter,word,stat(x));
       end
   else
       fprintf('Character %c no found in word %s\n',letter,word);
   end

Best Answer

Related Solutions

MATLAB: How to convert all the cell in a columns from char to string

MATLAB: Strings

Related Question