converting csv timestamp to datetime on import
18 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Russell Mott
am 28 Jun. 2022
Kommentiert: Stephen23
am 29 Jun. 2022
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 Kommentare
Akzeptierte Antwort
Stephen23
am 28 Jun. 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 Kommentare
Stephen23
am 29 Jun. 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:
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Text Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!