How to remove letters from cell arrays

When I import data from a speficic excel table, each row of one column comes as follows:

'2019-08-20T13:58:31Z'

In order to use 'datestr' or 'datevec', I need to delete the T and the Z on each row.

How can I delete these 2 letter for every row of the column?

Answer 1

[Stephen23]

Why do you need to delete them?

>> str = '2019-08-20T13:58:31Z';
>> datevec(str,'yyyy-mm-ddTHH:MM:SS')
ans =
        2019           8          20          13          58          31

[Guillaume]

Note that by using datevec you've completed lost the fact that the original dates were in the UTC timezone.

Answer 2

[Guillaume]

Don't use the ancient datestr or datevec particularly for dates as you have that are timezoned since these don't support time zones.

Instead use the modern datetime that fully understand time zones. To convert your dates to datetime:

d = datetime(yourcellvector, 'InputFormat', 'yyyy-MM-dd''T''HH:mm:ssZ', 'TimeZone', 'UTC');  %or use your own timezone instead of UTC. The time will automatically be adjusted to your timezone