converting csv timestamp to datetime on import
14 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a CSV that has two columns, Date and Time. The general format of the text is colum 1, Date, is m/DD/YYYY, and column2, Time, is HH:mm:ss SSS. However, the output device outputs the text for time omitting the zero in cases where the digit is not bordered by other numbers in its value category. For example, one case reads out:
HH:m:ss S (11:1:30 1)
when it should read HH:mm:ss SSS (11:01:30 001) if it generated equal length strings.
I cannot change the output device to correct this to always include 'HH:mm:ss SSS' to perform a simple string input to use in the datetime(DateStrings,'InputFormat',infmt) method as the string changes length.
0 commentaires
Réponse acceptée
Stephen23
le 28 Juin 2022
type test.csv
T = readtable('test.csv','Format','%{M/d/y}D%T%d','Delimiter',{',',' '})
D = T.Var1 + T.Var2 + milliseconds(T.Var3);
D.Format = 'yyyy-MM-dd HH:mm:ss.SSS'
2 commentaires
Stephen23
le 29 Juin 2022
The READTABLE documentation states for the FORMAT that "The conversion specifiers are the same as the specifiers accepted by the textscan function", so this would be the resource to read:
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Text Files dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!