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
file2
file2

采纳的回答

Voss
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 CenterFile Exchange 中查找有关 Dates and Time 的更多信息

产品


版本

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by