read mix data from .txt file
1 view (last 30 days)
Show older comments
I get my data from a txt file like this:
Date Flow
1950-01-01 38.745
1950-01-02 40.243
1950-01-03 40.343
1950-01-04 40.643
How can i get date on a matrix with a column for year, month and day. One other matrix for the flow. I dont need header.
Thank you for your help
0 Comments
Accepted Answer
Fangjun Jiang
on 1 Nov 2011
Assume your file is called test.txt
>> [Dat,Num]=textread('test.txt','%s %f','headerlines',1)
Dat =
'1950-01-01'
'1950-01-02'
'1950-01-03'
'1950-01-04'
Num =
38.744999999999997
40.243000000000002
40.343000000000004
40.643000000000001
>> [Year,Month,Day]=datevec(Dat)
Year =
1950
1950
1950
1950
Month =
1
1
1
1
Day =
1
2
3
4
0 Comments
More Answers (0)
See Also
Categories
Find more on Text Files 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!