Extract data (timestamps) from csv file

1 view (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)

Categories

Find more on File Operations in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!