- is StartContact the same as StartTime?
- why are you converting days, months, etc. to strings to parse them back into number in the datetime?
- Why the loop?
- What is the actual content of time and month?
datetime 'InputFormat' syntax
204 views (last 30 days)
Show older comments
I am looking to convert a cell array of dates to a datetime array. From the text file BUContactOutput.txt I need the Start Time and Stop time in separate datetime arrays. This section of code shows how I am going about creating the StartTime datetime array.
ContactData = readtable('BUContactOutput.txt',...
'Delimiter', ' ', 'HeaderLines',4);
NumOfContacts = height(ContactData);
StartTime = cell(NumOfContacts,1);
for i = 1:NumOfContacts
day = num2str(ContactData.Var1(i));
month = char(ContactData.Var2(i));
year = num2str(ContactData.Var3(i));
time = char(ContactData.Var4(i));
StartTime{i,1} = strcat(year,'-',month,'-',day,'-',time);
end
datetime(StartContact, 'InputFormat', 'yyyy-MMM-dd-HH:mm:SSS')
This method is successful when the time component of StartTime is not included (no ,'-',time in the strcat function and no -HH:mm:SSS in datetime function), yet is not successful when the time component is included. I believe I have a syntax error in my 'InputFormat' content. I am unsure how to resolve the issue and the documentation has yet to provide me with a solution.
https://www.mathworks.com/help/matlab/ref/datetime.html#
Thanks ahead to anyone who offers help.
-Emil
1 Comment
Guillaume
on 11 Oct 2017
A few questions
Accepted Answer
Guillaume
on 11 Oct 2017
Without seeing the actual format of time, it's difficult to know what the correct format should be. However, it's unusual to have SSS without a ss preceding it. So, possibly:
datetime(StartContact, 'InputFormat', 'yyyy-MMM-dd-HH:mm:ss.SSS')
See my comments to your question if that doesn't solve it.
Note: loop unneeded:
startTime = compose('%d-%s-%d-%s', ContactData.Var1, ContactData.Var2, ContactData.Var3, ContactData.Var4);
5 Comments
Peter Perkins
on 9 Aug 2022
You are correct that only one format is currently supported. But you are not correct that if only one timestamp among a large number is missing fractional seconds that the function errors. In fact, that error only occurs if NONE of the timestamps match the specified format (which includes the case of only one timestamp, and that one doesn't match). If only some of the timestamps don't match, the corresponding elements of the output are filled with NaT (Not a Time). If you have a large number of timestamps and are calling datetime on them one at a time, that's something to look at.
The work-around for a mix of formats is to call datetime with one format, then go back and, using isnat, read the ones that match the other format. Something equivalent to
dt = datetime(timestamps,InputFormat=fmt1);
dt(isnan(dt) )= datetime(dt(isnan(dt)),InputFormat=fmt2);
Steven Lord
on 9 Aug 2022
I think you have a typo on that second line. The first input to datetime should be the elements of timestamps corresponding to NaT values in dt, not the elements of dt. All those elements of dt are going to be NaT.
More Answers (1)
Steven Lord
on 11 Oct 2017
I suggest using the Import Tool. Using this you can experiment with datetime formats and column widths then import the data to a variable, generate a script file, and/or generate a function file. The latter two options allow you to use the results of your experimentation to automatically import other data files with the same format in the future or to tweak the import process.
For your file, I removed the delimiters separating each of the components of your start and stop times from the default (which were set by using spaces as the delimeter.) I changed the first two columns to import as datetime arrays using the custom format dd MMM yyyy HH:mm:ss.SSS. Hovering over one of the elements in columns A and B showed me that each would import correctly. I then selected to read column C as a number and imported it and the results were what I expected.
2 Comments
Steven Lord
on 11 Oct 2017
Use the Import Tool once to generate a function file that imports the first data file.
Run the generated function file to import the second, third, fourth, etc. data files.
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!