Borrar filtros
Borrar filtros

Remove datetime values from a table

2 visualizaciones (últimos 30 días)
Marcus Johnson
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
file2
file2

Respuesta aceptada

Voss
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
Marcus Johnson
Marcus Johnson el 4 de Oct. de 2023
Yeah, that's what I meant. Thanks!
Voss
Voss el 4 de Oct. de 2023
You're welcome!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Productos


Versión

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by