Join multiple readtable data with WeirdDuration
조회 수: 2 (최근 30일)
이전 댓글 표시
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
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
2020년 1월 7일
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개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import and Analysis에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!