Separating a column in two others when there are empty cells

Guys,

I have the following cell Column

' '

    '4W231108'

    '4W211208'

    '4W180109'

    '4W150209'

    '4W150309'

    '4W120409'

AS you can see the first element of the above column is empty

and I want to obtain Column 1 column 2

“ ” ““

'4W 231108'

    '4W              211208'

    '4W              180109'

    '4W              150209'

    '4W              150309'

    '4W               120409'

Any suggestions?

thanks

Answer 1

[Sean de Wolski]

How about this hideous idea?

C = {''; '4W231108'   ; '4W211208'  ;  '4W180109'  ;  '4W150209'   ; '4W150309'   ; '4W120409'}

C2 = cellfun(@(x)[{x(1:min(numel(x),2))} {x(3:end)}],C,'uni',false);
C2 = vertcat(C2{:});

[antonet]

Excellent!

[antonet]

I forgot to tell you that I wanted to have

'4W 23/11/08'

'4W 21/12/08'

'4W 18/01/09'

'4W 15/02/09'

'4W 15/03/09'

'4W 12/04/09'

[Sean de Wolski]

then just add a space instead of two cells

[x(1:min(numel(x),2)) ' ' x(3:end)],

[antonet]

I tried but it does not work

[antonet]

C2 = cellfun(@(x)[x(1:min(numel(x),2)) ' ' x(3:end)], C,'uni',false);

C2 = vertcat(C2{:});

[antonet]

I still get 231108 211208 and so forth....

[Sean de Wolski]

Well did you copy C in ?

[antonet]

what do you mean?