Extract data (timestamps) from csv file

7 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 File Operations 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