How to remove letters from cell arrays
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Matheus Pacifici
il 30 Ago 2019
Commentato: Guillaume
il 30 Ago 2019
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 Commenti
Risposta accettata
Stephen23
il 30 Ago 2019
Modificato: Stephen23
il 30 Ago 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 Commento
Guillaume
il 30 Ago 2019
Note that by using datevec you've completed lost the fact that the original dates were in the UTC timezone.
Più risposte (1)
Guillaume
il 30 Ago 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 Commenti
Vedere anche
Categorie
Scopri di più su Dates and Time in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!