separating cell array into several columns MATLAB

Question

I have a cell array with one column. Each row consists of only one column. Each cell consist of a String. How can I separate the content of one column in cell array into several columns by separating the string based on space. Each string has different length. Example:

cellArrayM= {
  'hh pp'
  'my 2 ewr 3234 csdf'
  'input l 34'
  'output K 99 100'
 }

result={
   'hh'     'pp' []    []     []
   'my'     '2' 'ewr' '3234' 'csdf'
   'input'  'l' '34'  []      []
   'output' 'k' '99'  '100'   []
         }

can you please show me an example if possible – ryh12 Jul 25 '17 at 02:08 — ryh12, Jul 25 '17 at 02:08

score 1 · Accepted Answer · answered Jul 25 '17 at 08:50

1

You can do it this way:

x = cellfun(@(x) strsplit(x), cellArrayM, 'uniformoutput', 0);
result = cell(numel(x), max(cellfun(@numel, x)));
for k = 1:numel(x)
    result(k, 1:numel(x{k})) = x{k};
end

answered Jul 25 '17 at 08:50

Luis Mendo

110,752
13
76
147

This function is good, but it is very slow when the array is large. Is there a way to make it faster? @Luis Mendo – ryh12 Jul 29 '17 at 02:04
I can't think of any. Working with cells is usually slow – Luis Mendo Jul 29 '17 at 08:55

score -1 · Answer 2 · edited Jul 25 '17 at 05:47

-1

You can do like this:

splitCellArray = regexp(cellArrayM,' ','split')

edited Jul 25 '17 at 05:47

techdreams

5,371
7
42
63

answered Jul 25 '17 at 03:00

Dong

1

separating cell array into several columns MATLAB

2 Answers2

Linked