Remove datetime values from a table
4 次查看(过去 30 天)
显示 更早的评论
Hello,
I have two tables with datetime values in their respective .Var3 variable (the dates in file2/second image continues to 2023). So my question is:
How do I remove all dates from file2.Var3 that are not the dates in file1.Var3? So, I want to remove all dates from file2.Var3 that does not exist in file1.Var3, what's the easiest way to do that?
Please tell me if you need more information.
Thanks
file1
![file1](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1502019/file1.png)
file2
![file2](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1502024/file2.png)
采纳的回答
Voss
2023-10-4
"I want to remove all dates from file2.Var3 that does not exist in file1.Var3"
I assume you mean to remove the rows from the table file2 where file2.Var3 does not exist in file1.Var3.
file2(~ismember(file2.Var3,file1.Var3),:) = [];
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!