How to remove letters from cell arrays
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Matheus Pacifici
el 30 de Ag. de 2019
Comentada: Guillaume
el 30 de Ag. de 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 comentarios
Respuesta aceptada
Stephen23
el 30 de Ag. de 2019
Editada: Stephen23
el 30 de Ag. de 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 comentario
Guillaume
el 30 de Ag. de 2019
Note that by using datevec you've completed lost the fact that the original dates were in the UTC timezone.
Más respuestas (1)
Guillaume
el 30 de Ag. de 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 comentarios
Ver también
Categorías
Más información sobre Dates and Time en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!