清空筛选条件
清空筛选条件

How to remove letters from cell arrays

5 次查看（过去 30 天）
Matheus Pacifici
Matheus Pacifici 2019-8-30
评论： Guillaume 2019-8-30
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?

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2019-8-30
编辑：Stephen23 2019-8-30
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
  1 个评论
Guillaume
Guillaume 2019-8-30
Note that by using datevec you've completed lost the fact that the original dates were in the UTC timezone.

请先登录，再进行评论。

更多回答（1 个）

Guillaume
Guillaume 2019-8-30
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

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by