How to remove letters from cell arrays
5 views (last 30 days)
Show older comments
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?
0 Comments
Accepted Answer
Stephen23
on 30 Aug 2019
Edited: Stephen23
on 30 Aug 2019
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 Comment
Guillaume
on 30 Aug 2019
Note that by using datevec you've completed lost the fact that the original dates were in the UTC timezone.
More Answers (1)
Guillaume
on 30 Aug 2019
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
0 Comments
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!