Converting a Column to Numeric for Date/Time Format
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Sarah Nolt-Caraway
el 23 de Mzo. de 2021
Comentada: Adam Danz
el 23 de Mzo. de 2021
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/559608/image.png)
I am trying to convert the first column to a character string, so I can split the character string values to create a Date/Time format to sort data later on. When I try to isolate the column in Matlab, it skips the first column and uses only the second column. Can anyone help me isloate the first column?
This is what I have tried so far
T = xlsread('Vibes.xlsx');
C = str2double(T(:,1));
T = xlsread('Vibes.xlsx');
C = T(:,1);
0 comentarios
Respuesta aceptada
Steven Lord
el 23 de Mzo. de 2021
If you use the Import Data tool (in the Variable section on the Home tab of the toolstrip) you can import the data directly as a datetime array. Just specify the format. If you have multiple of these files in the same format to import, you could even create a script or function to automate the import process for the second and later files (and to see the code MATLAB used to import the data so you can learn from it.)
3 comentarios
Adam Danz
el 23 de Mzo. de 2021
They underscore can be included in the input format.
date = '2020-09-11_04:11:50.648000';
datetime(date,"InputFormat",'yyyy-MM-dd_hh:mm:ss.SSSS')
Más respuestas (0)
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!