MATLAB: Replace numeric char within a column

replace numeric char within a column

Hey,

I would like to replace numbers (-999) as char with a 0 for all -999 in a specific column.

Thanks already!

Best Answer

Hi,

it sounds as if you have a cell array of strings. In this case

allDatabySubj(strcmp(allDatabySubj, '-999)) = {0};

should do the trick.

Titus

Related Solutions

MATLAB: Number to string and char to string in table

% Create fake data
T = table((1:5)',('a':'e')','VariableNames', {'col1','col2'});
% Convert num-to-string and char-to-string
T.col1 = string(T.col1); 
T.col2 = string(T.col2);

More info on characters vs. strings:

https://www.mathworks.com/help/matlab/characters-and-strings.html

MATLAB: Dynamic ranges using xlswrite

You can do this by dynamically creating the character string that you send to xlswrite to specify xl range.

Something like this:

>> firstRow = 1;
>> lastRow = 5;
>> firstCol = 'C';
>> lastCol = 'AY';
>> cellRange = [firstCol,num2str(firstRow),':',lastCol,num2str(lastRow)]
cellRange =
C1:AY5

The only thing left, is to figure out what "lastCol" is based on the column number. I wrote a function to do this myself a little while back. I know there are other versions floating around as well.

For example:

>> xlcolumnletter(51)
ans =
AY

Here's the code:

function colLetter = xlcolumnletter(colNumber)
% Excel formats columns using letters.
% This function returns the letter combination that corresponds to a given
% column number.
% Limited to 702 columns
if( colNumber > 26*27 )
    error('XLCOLUMNLETTER: Requested column number is larger than 702. Need to revise method to work with 3 character columns');
else
    % Start with A-Z letters
    atoz        = char(65:90)';
      % Single character columns are first
      singleChar  = cellstr(atoz);
      % Calculate double character columns
      n           = (1:26)';
      indx        = allcomb(n,n);
      doubleChar  = cellstr(atoz(indx));
      % Concatenate
      xlLetters   = [singleChar;doubleChar];
      % Return requested column
      colLetter   = xlLetters{colNumber};
  end

Best Answer

Related Solutions

MATLAB: Number to string and char to string in table

MATLAB: Dynamic ranges using xlswrite

Related Question