Extract data (timestamps) from csv file

3 Ansichten (letzte 30 Tage)
Sean Mark L
Sean Mark L am 3 Mär. 2020
Bearbeitet: Turlough Hughes am 4 Mär. 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

Akzeptierte Antwort

Turlough Hughes
Turlough Hughes am 3 Mär. 2020
Bearbeitet: Turlough Hughes am 4 Mär. 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 Kommentar
Sean Mark L
Sean Mark L am 4 Mär. 2020
Thank you, it worked perfectly. I could not get my head around how to do it but I understand now.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu File Operations finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by