Remove datetime values from a table
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Marcus Johnson
el 4 de Oct. de 2023
Comentada: Voss
el 4 de Oct. de 2023
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)
Respuesta aceptada
Voss
el 4 de Oct. de 2023
"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),:) = [];
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Dates and Time en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!