Add datetime format to cell array in Matlab

Question

I have a cell array that I call "Table", as in the code below (but my array has more lines). Column 1 contains dates in string format. I want to add an additional column that contains the dates in datetime format. I did the following, which works, but it is VERY slow. What are the alternatives?

% Table that I have:

Table{1,1} = 'Stringdate';
Table{2,1} = '01.01.1999';
Table{3,1} = '02.01.1999';
Table{4,1} = '03.01.1999';
Table{5,1} = '04.01.1999';

% What I want to add:

Table{1, size(Table,2)+1} = 'Datetime';

for index = 2:length(Table)
    Table{index, size(Table,2)} = datetime(Table{index, 1});
end

The code runs perfectly on my machine?! Feel free to change it if it doesn't work for you and thanks in advance for any help — LenaH
– LenaH, Commented Feb 4, 2018 at 11:54

Sardar Usama · Accepted Answer · 2018-02-04 11:55:24Z

3

You can apply datetime to all of them in one-go and use just num2cell and indexing to achieve the same result as that of your loop.

Table(2:end,2) = num2cell(datetime(Table(2:end,1)));
%You might need to specify the InputFormat as well i.e.
%Table(2:end,2) = num2cell(datetime(Table(2:end,1),'InputFormat','dd.MM.yyyy'));

answered Feb 4, 2018 at 11:55

Sardar Usama

19.7k9 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add datetime format to cell array in Matlab

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related