Join multiple readtable data with WeirdDuration

1 view (last 30 days)
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 Comments
Life is Wonderful
Life is Wonderful on 2 Jan 2020
Edited: Life is Wonderful on 2 Jan 2020
Any suggestion and help, thank you!!
Adam Danz
Adam Danz on 2 Jan 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.

Sign in to comment.

Accepted Answer

Adam Danz
Adam Danz on 7 Jan 2020
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]';
% ^^

More Answers (1)

Life is Wonderful
Life is Wonderful on 8 Jan 2020
Edited: Life is Wonderful on 8 Jan 2020
I have raised a new issue. Can you please look in the below link and please help me . Thank you

Categories

Find more on Tables 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!