Find missing dates from a file
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ioanna Thoma
el 21 de Mayo de 2020
Comentada: Star Strider
el 21 de Mayo de 2020
I have a .txt file (attached) with some dates. There are missing dates and I would like to automatically create a file with these missing dates.
For example I have 1/1/2018,3/1/2018 but 2/1/2018 is missing, so I wtould like to have a matrix or file with this date. Any help please?
0 comentarios
Respuesta aceptada
Star Strider
el 21 de Mayo de 2020
Try this:
fidi = fopen('Dates.txt');
D = textscan(fidi, '%{dd/MM/yyyy}D')
fclose(fidi);
AllDates = (D{1}(1):caldays(1):D{1}(end)).';
MissingDates = setdiff(AllDates,D{1});
The ‘MissingDates’ datetime array has the dates between the start and end of the dates in the file that are not in the file.
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Time Series Objects 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!