Reading in a text file with date and time

2 views (last 30 days)
John
John on 16 Apr 2014
Edited: dpb on 18 Apr 2014
I have a text file (e.g. discharge.txt) that I wish to read in in the following format:
Date Discharge (m3/s)
09/04/2014 10:15 9.587*
09/04/2014 10:30 9.497*
09/04/2014 10:45 9.363*
09/04/2014 11:00 9.231*
09/04/2014 11:15 9.143*
I would ideally wish to obtain 6 vectors.
  • A vector showing the integer value for month
  • A vector showing the integer value for year
  • A vector showing the integer value for day
  • A vector showing the integer value for hour
  • A vector showing the integer value for minute
  • A vector showing the value for discharge (no asterisk)
Thanks!

Answers (1)

dpb
dpb on 17 Apr 2014
Edited: dpb on 18 Apr 2014
[m,d,y,h,mn,disch]=textread('discharge.dat','%d/%d/%d %f*');
doc textread
doc textscan
doc fscanf
help iofun
Read "Getting Started"

Community Treasure Hunt

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

Start Hunting!