Join multiple readtable data with WeirdDuration

1 次查看（过去 30 天）
Life is Wonderful
Life is Wonderful 2019-12-24
编辑： Life is Wonderful 2020-1-28
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 个评论
显示 9更早的评论
Adam Danz
Adam Danz 2020-1-2
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.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Adam Danz
Adam Danz 2020-1-7
In your formatSpec,
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]';
% ^^

更多回答（1 个）

Life is Wonderful
编辑：Life is Wonderful 2020-1-8
Hi Adam Danz and Guillaume
I have raised a new issue. Can you please look in the below link and please help me . Thank you
https://in.mathworks.com/matlabcentral/answers/499409-error-in-joining-multiple-date-time-duration-id-date-is-in-cell-array

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by