Extract data (timestamps) from csv file

2 views (last 30 days)
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

Accepted Answer

Turlough Hughes
Turlough Hughes on 3 Mar 2020
Edited: Turlough Hughes on 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 Comment
Sean Mark L
Sean Mark L on 4 Mar 2020
Thank you, it worked perfectly. I could not get my head around how to do it but I understand now.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!