Extract data (timestamps) from csv file

2 vues (au cours des 30 derniers jours)
Sean Mark L
Sean Mark L le 3 Mar 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
  1 commentaire
Rik
Rik le 3 Mar 2020
What have you tried so far?

Connectez-vous pour commenter.

Réponse acceptée

Turlough Hughes
Turlough Hughes le 3 Mar 2020
Modifié(e) : Turlough Hughes le 4 Mar 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 commentaire
Sean Mark L
Sean Mark L le 4 Mar 2020
Thank you, it worked perfectly. I could not get my head around how to do it but I understand now.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Workspace Variables and MAT-Files dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by