MATLAB: How to return first 5 digits of 6th column in cell array

cell array; indexing

Hi Matlab community,

Here's another newbie question. I would like to replace the 6th column with the first 5 digits of that column (20134); I would then like to create a 7th column that is the last digit of the 6 column. Here's a sample array.

Thank-you for your help.

 cell = {'this' 'is' 'a' 'cell' 'array' '2013420134' }

Best Answer

Ok found it; thanks anyway all

cell{1,5}(1:5)

Related Solutions

MATLAB: Reading only a portion of a text file

fid = fopen('mydata.txt', 'r'); tline = fgetl(fid); k=1;

while ischar(tline) disp(tline) findrows = strfind(tline, 'ARR++'); if ~isempty(findrows) Data{k,:} = tline(:); k=k+1; end tline = fgetl(fid); end

fclose(fid);

filename = 'mydata_1.txt';

%this function converts the cell array back to a text file. found here: cell array to text file file;

cell2text(filename,Data);

%open file fid = fopen(filename, 'r'); %figure out how many columns are there firstline = fgetl(fid); ncol = 1 + sum(firstline == ':'); %reset to beginning of file fseek(fid,0,0); %read data data = textscan(fid,repmat('%s',1,ncol),'Delimiter',':','CollectOutput',1); data = data{:,:}; data = data(:,[3:7 9:12 14 16]);

[m,n]=size(data);

for i = 1:m data1{i,9} = data{i,9}(1:5); data{i,9} = {}; data{i,9} = data1{i,9}; end

%close file fclose(fid);

MATLAB: Creating a loop to use all columns in a dataset array

data = dataset({('a':'z').','names'},{rand(26,2),'mv1','mv2'});

EDIT

% Retrieve column names/variables (from second onwards)

varnames = data.Properties.VarNames(2:end);
nV = numel(varnames);

% Preallocate

C = cell(1,nV);

% Loop per each column (variable)

for v = 1:nV
    idx = data.(varnames{v}) < median(data.(varnames{v}));
    C{v} = data.(varnames{v})(idx);
    C{v} = data(idx,[1 v]);
end

Best Answer

Related Solutions

MATLAB: Reading only a portion of a text file

MATLAB: Creating a loop to use all columns in a dataset array

Related Question