Extract data (timestamps) from csv file

2 visualizaciones (últimos 30 días)
Sean Mark L
Sean Mark L el 3 de Mzo. de 2020
Editada: Turlough Hughes el 4 de Mzo. de 2020
I have a CSV file containing ~14000 rows with hundreds of timestamps.
I am trying to extract all the timestamps from the attahced csv file. Any help with coding please will be appreiacted.
Thanks

Respuesta aceptada

Turlough Hughes
Turlough Hughes el 3 de Mzo. de 2020
Editada: Turlough Hughes el 4 de Mzo. de 2020
You could read the file in as a character vector with fileread and then use regexp as follows:
filetext = fileread('Info.csv');
t = str2double(regexp(filetext,'(?<=Time=)\d*','Match')).';
  1 comentario
Sean Mark L
Sean Mark L el 4 de Mzo. de 2020
Thank you, it worked perfectly. I could not get my head around how to do it but I understand now.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Workspace Variables and MAT-Files 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!

Translated by