Strip duration row with time duration 00:00:00:000

Hi

I want to remove all rows expect the last with duration 00:00:00:000

Sample out data

Answer 1

[Adam Danz]

I'm assuming the WeirdDuration data are duration values. This simple solution assumes that you want to eliminate all rows starting at the first row until the last rows that contains a duration of 0.

% T is the table
lastZeroIdx = find(T.WeirdDuration == duration(0,0,0), 1,'last'); 
T(1:lastZeroIdx-1,:) = []

[update]

if WeirdDuration are not duration values, you can easily modifty the line of code above to use datetime values instead. Example: datetime(0,0,0)

[Guillaume]

I think I'm responsible for the name WeirdDuration. IIRC, I used that name because the OP (under another name?) wanted to calculate time elapsed between dates but completely ignoring the day/month/year. So I named it WeirdDuration to highlight that there was something iffy about that approach. That was a long time ago, so I find it a bit amusing that the name is still used.

[Adam Danz]

Ha! it has indeed propagated through the forum

Same OP

• The birth of WeirdDuration, thanks to Guillaumehttps://www.mathworks.com/matlabcentral/answers/476102-mutiple-time-series-synchronization
• https://www.mathworks.com/matlabcentral/answers/493926-how-to-stackedplot-with-text-data
• https://www.mathworks.com/matlabcentral/answers/488701-extract-structure-element-dynamically
• https://www.mathworks.com/matlabcentral/answers/476858-reading-content-of-a-file-using-readtable-return-nat-for-time
• https://www.mathworks.com/matlabcentral/answers/492563-app-designer-axis-issue-xlim-and-dataticks
• https://www.mathworks.com/matlabcentral/answers/479315-filecopy-does-t-work

[Guillaume]

Oh yes, thanks for digging it out, it's even worse than I remember. the WeirdDuration is just the time part of a date which for some reason is to be considered a duration.

[Jogger]

Glad to have Guillaume and Adam in mentor roles.

The theory is interesting and Guilaume stated above WeirdDuration belongs to him is right statement and I am not going to remove it ( I like it as well).

I had several files with unusal time stamp format. I have to bring them on same page to view the result's ( data look completly asynchronous in the begining). I don't know what to do with it and how to analyze full set of text result files . Probably one thing was common and it was time factor ( It is WeirdDuration). It has indeed propagated from Guillaume pointers where now I am in a state of achievement ( my target goal to develop a Text Analysis Toolbox ).... By the way I still have one or more file where I need help. So it will continue some more propagation. Don't get surprised

The back ground for this question is below line of code

                1. joinedtimetable = outerjoin(joinedtimetable, structtimetable,'Merge',true);   % 'LeftKeys','RightKeys'
                2. joinedtimetable = synchronize(joinedtimetable, structtimetable, 'union'); %subsequent times, synchronize. Choose whichever method is prefered

If i use synchronize , it will strip few data and missing data from analysis is NOT ok. So I moved to outerjoin and I get full data but with lot of unwanted data ( duration : 00:00:00:000) stuff which increased result size and I want to throw away eventually

Post Fix , now the result look below . Works as expected. Perfect. Many Thanks

Wish you a super morning . Appreciate and thank you once again.

[Adam Danz]

If you used the method in my answer as a fix, just keep in mind that it will eliminate all rows of data from row 1 until the last row of 0s no matter what data are between. If you expect your timestamps to be in ascending order starting with 0s, then this simple method should be OK.

Glad I could help with your weird durations ;)

[Jogger]

Hi Guillaume and Adam

Can you please look into below link issue and help me .

https://in.mathworks.com/matlabcentral/answers/497917-join-multiple-readtable-data-with-weirdduration

Thanks a lot!!

+ One more topic

https://in.mathworks.com/matlabcentral/answers/497919-parfeval-waitbar-progress-meter

Many thanks