extracting the second column of all cells of a struct

I have a struct, x1_surf, that contains 1070 cells, each cell has 4 cells, now I want to extract the second column of the inner cells with the order.

This is x1_surf

This is the x1_surf{1,1}

now, I want to extract the second column of all inccer cells with the correct order, I mean x1_surf{1,:}{1,2}

I write a script like that:

It works correcly for some files, however for some other files, the order of the date is mixed up and they are not in the right order. Could anyone help me how I can rewise it?

[Stephen23]

You should replace all of the nested 1x4 cell arrays with TIMETABLEs or TABLEs.

Answer 1

[David Hill]

for k=1:length(x1_surf)
    x2_surf{k}=x1_surf{k}{2};
end

[Sahar khalili]

Thank you, but this does not put the content of the second coulmn of the inner cells in order. I want the dates to be in x2_surf

The one you wrote gave me this result

[Image Analyst]

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[Sahar khalili]

Here is my code

load x1_surf.mat

for j = 1: length(x1_surf{1, 1}{1, 2}) 
	x2_surf(j,1) =  x1_surf{1,1}{1,2}(j,1) ; 
end
for k = 2 : 1070   
     for j = 1: length(x1_surf{1, k}{1, 2}) 
          x2_surf ((length(x1_surf{1, k-1}{1, 2} ))*(k-1)+j,1) =  x1_surf{1,k}{1,2}(j,1) ;
     end
end

[David Hill]

I am assuming you just want just one listing of all the date-times.

load('x1_surf.mat');
x2_surf=[];
for k=1:length(x1_surf)
    x2_surf=[x2_surf;x1_surf{k}{2}];
end
x2_surf(1:20)

ans = 20×1 datetime array
   11-Sep-2019 13:29:00
   11-Sep-2019 13:39:00
   11-Sep-2019 13:49:00
   11-Sep-2019 13:59:00
   11-Sep-2019 14:09:00
   11-Sep-2019 14:19:00
   11-Sep-2019 14:29:00
   11-Sep-2019 14:39:00
   11-Sep-2019 14:49:00
   11-Sep-2019 14:59:00
   11-Sep-2019 15:09:00
   11-Sep-2019 15:19:00
   11-Sep-2019 15:29:00
   11-Sep-2019 15:39:00
   11-Sep-2019 15:49:00
   11-Sep-2019 15:59:00
   11-Sep-2019 16:09:00
   11-Sep-2019 16:19:00
   11-Sep-2019 16:29:00
   11-Sep-2019 16:39:00

[Sahar khalili]

Thank you so much, it worked.