Join multiple readtable data with WeirdDuration
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Life is Wonderful
el 24 de Dic. de 2019
Editada: Life is Wonderful
el 28 de En. de 2020
I need help in join the readtablefcn with attached files to an exsisting routine so that I can combine multiple table data.
I have file with different format and I join them using below routine. Example
11 comentarios
Adam Danz
el 2 de En. de 2020
Hi again, I just spent about 20+ minutes re-reading the comments and going through the code and I still cannot understand exactly what we're trying to fix. I'd like to help but I it's just taking too much time to sift through all of this in order to understand the problem - even at a big picture level.
This is why is important to reproduce the problem with as little code as possible in order to provide a Minimal Working Example. Ideally, you'll get the fastest responses when the problem is described super clearly in just a few sentences and we can copy a short bit of code into our workspace that demonstrates the problem.
Respuesta aceptada
Adam Danz
el 7 de En. de 2020
formatSpec = '%*6s%13{hhmmss.SSSSSS}D%C%[^\n\r]';
note that you're using lower case hh which is for 12-hour clocks. It works for the update_engine data because the hours are all less than 12:00. But it doesn't work for the powerd data because 17:40:01 is greater than 12:00.
You need to use 24-hour clock notation by using upper case HH.
formatSpec = '%*6s%13{HHmmss.SSSSSS}D%C%[^\n\r]';
% ^^
Más respuestas (1)
Ver también
Categorías
Más información sobre Tables 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!