MATLAB: Split the given string into characters

data split

I have a column in my table that has values such as '2.6ELKUxQKWPVJVHxxxxC.4xxxIxSxJJxxxxx', it has altogether 37 single characters. I want to split the string into 37 different columns for further data analysis. I have tried using 'split' function, but it doesn't work.

Best Answer

Here's an example for 8 columns. You can expand it to 37 columns.

ca = {'1.6ELKUxQKWPVJVHxxxxC.4xxxIxSxJJxxxxx'; '2.6ELKUxQKWPVJVHxxxxC.4xxxIxSxJJxxxxx'; '3.6ELKUxQKWPVJVHxxxxC.4xxxIxSxJJxxxxx'}
t = cell2table(ca)
% Now we have our table.
% Extract this one column:
col1 = t{:,1}
% Make 37 cell arrays
ca1 = cell(37, 1);
ca2 = cell(37, 1);
ca3 = cell(37, 1);
ca4 = cell(37, 1);
ca5 = cell(37, 1);
ca6 = cell(37, 1);
ca7 = cell(37, 1);
ca8 = cell(37, 1);
for row = 1 : length(col1)
  thisRow = col1{row};
  ca1{row} = thisRow(1);
  ca2{row} = thisRow(2);
  ca3{row} = thisRow(3);
  ca4{row} = thisRow(4);
  ca5{row} = thisRow(5);
  ca6{row} = thisRow(6);
  ca7{row} = thisRow(7);
  ca8{row} = thisRow(8);
end
t2 = table(ca1, ca2, ca3, ca4, ca5, ca6, ca7, ca8)

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: Whenever I import data from excel, one of the column that contains values such as 2.1ELKFJQLHxxxMxxxxxSx4xxxIxSxJJxxxxx, ends up with NaN in Matlab table.

You forgot to post your code. I guess it is:

[num, txt, raw] = xlsread(FileName);

Now you observe, that the file of num is set to NaN, if the Excel sheet contains the data

2.1ELKFJQLHxxxMxxxxxSx4xxxIxSxJJxxxxx

This is the expected and wanted behavior, because this is not a number. The field is imported in the 3rd output raw in its native format, as explained in the documentation.

Or may you use readtable? This is the problem when not posting the code: Writing an answer requires guessing. If so, specify the 'Format' accordingly, such that this field is not interpreted as a number.

Best Answer

Related Solutions

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

MATLAB: Whenever I import data from excel, one of the column that contains values such as 2.1ELKFJQL​HxxxMxxxxx​Sx4xxxIxSx​JJxxxxx, ends up with NaN in Matlab table.

Related Question

MATLAB: Whenever I import data from excel, one of the column that contains values such as 2.1ELKFJQLHxxxMxxxxxSx4xxxIxSxJJxxxxx, ends up with NaN in Matlab table.