How to extract year and month from attached string.

I want to extract year and month from attached string data. Please help me.

Thank you so much in advance.

Regard's

Varunesh

Answer 1

[madhan ravi]

load('date.mat');
a=date{:,:};
b=regexp(a,'\T','split');
b=[b{:}];
B=datetime(b(1:2:end).','InputFormat','yyyy-MM-dd');
[year,month,day]=ymd(B);

[madhan ravi]

If you want them to display it as table finally after splitting then:

Result=[year month day];
T=array2table(Result);
T.Properties.VariableNames={'Year','Month','Day'};

[varunesh]

Thank you so much. It is working.

Can you help me with another question? Please look once, If possible then please help me. a link is below.

https://in.mathworks.com/matlabcentral/answers/438878-need-help-regarding-hurdat2-dataset-for-atlantic-hurricane-data

[madhan ravi]

Anytime :) , not sure if I can help with that though sorry.

Answer 2

[Walter Roberson]

times = datetime(date.datetime, 'InputFormat', 'yyyy-MM-dd''T''HH:mm:ss');

By the way, your times are not completely sorted.